- Joined
- Feb 8, 2002
- Messages
- 3,391
- Office Version
- 365
- Platform
- Windows
I have a chart with three series.
Series 1 runs from A3:M3
Series 3 runs from A5:M5
Series 2 has to run from A4.Resize(1, x) where x changes each month.
What is the code to change just that one series?
SetSourceData affects the whole chart.
I am here in a room with only Excel 2007, where of course the macro recorder returns nothing.
Thanks in Advance!
Bill
Series 1 runs from A3:M3
Series 3 runs from A5:M5
Series 2 has to run from A4.Resize(1, x) where x changes each month.
What is the code to change just that one series?
SetSourceData affects the whole chart.
I am here in a room with only Excel 2007, where of course the macro recorder returns nothing.
Thanks in Advance!
Bill