Updating Chart Range

[mep1]

Hello,
I am trying to update a chart range programmatically. The code I am using is given below. The error I receive states that I am unable to set the Xvalues this way.

Set dateRangeStart = Worksheets("HISTORY&quot.Range("A4&quot
ActiveChart.SeriesCollection(1).XValues = dateRange

I have also tried
ActiveChart.SeriesCollection(1).XValues = dateRange.currentRegion

but this updates the Xvalues with an incorrect range.

Thanks,
Mep

 

[SkipVought]

mep,

Unless you do it somewhere else, you have never defined dateRange.


Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884