VBA - Setting up a Chart series

[C Brandt]

Probably very elementary, but I need some more help.



I have set up a chart to show data just the way I like it and the only thing
I want to do is change the series data.

Fundamentally, I have a table with dates from Jan '05 to July '07 with
client's data for that entire period. What I would like to do is show
snapshots of that data using varying Start and Stop dates. I have calculated
the index for both the start and stop dates and would like to pop them into
the Series for the chart.



When I do this manually, I get something like below:



ActiveChart.SeriesCollection(2).XValues = "='Chart Setup'!R642C27:R925C27"



I tried using:



ActiveChart.SeriesCollection(2).XValues = "='Chart Setup'!R" & StrtDate
"C27:R925C27"



Where StrtDate is the row number, but it doesn't work.



What is a very simple way of doing this?



Thanks,

Craig

 

[Jon Peltier]

The syntax is fine. What type of chart is it? Is the series already visible,
or does it not yet have plottable data? Does StrtDate actually equal
something?

- Jon

 

[C Brandt]

Jon:

This line gives me a Compile Error - Syntax Error.

ActiveChart.SeriesCollection(1).XValues = "='Chart Setup'!R" &
StrtDatePtr "C27:R9525C27"

Craig

 

[C Brandt]

Jon:
When I remove all the spaces, it gives me Compile error - Expected; End of
Statement with the last group inside quotes highlighted.
Craig

 

[Jon Peltier]

You left out an ampersand between StrtDatePtr and "C27:R9525C27".

- Jon