Questions tagged [dynamic-chart-series]
23 questions
0
votes
0 answers
Excel Multiple Dynamic Charts
I have some excel data which I have variable number of Columns. The data is like the one shown in the picture but have longer trend
Now, I want to have sepearate sheet where I will only few column names, e.g. A,b,c and charts should be made on the…
AWA
- 3
- 5
0
votes
1 answer
Live chart that updates as it recieves data from multiple textbox's VB Visual Studio
I have a chart in a project that I am working on that I require to update its values as each textbox is input so the user can track the linearity.
The only way I can think of with my basic knowledge is to calculate the chart at each textbox value…
S Mac
- 58
- 9
0
votes
1 answer
Dynamic chart formula
I'm having major problems with a dynamic chart.
I have two pivot tables where one is a "compare" and the other is todays live values.
Because the timestamps does not match up I use a vlookup to make them match.
As you can see the values in the…
Andreas
- 23,610
- 6
- 30
- 62
0
votes
0 answers
How to show only one name on each chart series
I am creating a chart with multiple series and i would like to show only one series name for each series like the example shown at the picture.1
I have different series like series[4], series[5] with spline chartType and the name of the each series…
Ali
- 33
- 9
0
votes
1 answer
quantmod, not able to loop through chartSeries
install.packages("quantmod")
library(quantmod)
company_list <- c("AMD","AMZN","JPM","GOOG","COST")
for (i in 1:length(company_list)){
symbol <- company_list[i]
data_in <- as.name(symbol)
getSymbols(symbol)
chartSeries(data_in,subset="last 9…
Jiaoyan Huang
- 49
- 9
0
votes
1 answer
Excel VBA - How to select a dynamic range of cells for a chart series collection?
Im trying to define a chart series collection that goes from a determined cell to the end of data (down and right).
I used the following code to set up the labels of the axis:
oGrafico.Chart.SeriesCollection(nNoSerie).XValues =…
RicS
- 1
- 1
-1
votes
1 answer
Excel VBA graph range that moves down when updated always showing 2 months of data
I have constructed Stacked cluster chart in excel with this method: http://www.tushar-mehta.com/excel/charts/stacked_columns.htm
Now I want the chart to be dynamic and show last two months of daily data but as I have blank rows it is difficult with…
T0mat0
- 3
- 3
-3
votes
1 answer
Time Series date format DD:mm:yy HH:mm:ss to DD:mm:yy in R
My date column gives me NA values when I try to change the time series date format.
DATASET :
Date IIP CPI Term.Spread RealMoney NSE50 CallMoneyRate
1 2013:01:00 107.2 104.6 -0.059420 81740.83 6023.117 8.001140
2 2013:02:00 101.4…
sana
- 27
- 7