VBA Chart Data Series

[SBF12345]

I have charts generated in VBA. The chart output creates a data series that is something like "worksheet!$A$10:$A$40".

I would like the chart data to be reversed so that the first value on the chart is $A$40 and it goes to $A$10. Is there anyway I can do this?

I am using the code below to set the source data. It doesn't seem to do anything if I flip flop the string variables RngXR and RngXR2

.SeriesCollection(1).Values = ActiveWorkbook.Worksheets("ActiveSheet").Range(RngXR, RngXR2)

 

[pgc01]

Hi

Try adding:

.Axes(xlCategory).ReversePlotOrder = True

 

[SBF12345]

great, it seems to be working, Thanks!

 

[pgc01]

You're welcome.