Chart source data - VBA

[Coaster]

Hi,

How do I define a chart's source data in VBA? Is it possible? I can't seem to find the command to do so

Thanks

[teylyn]

Coaster,

start the macro recorder, select some data, create a chart. Select a chart series, change the data source. Stop the macro recorder. Study the code.

This is for Excel 2003. If you use 2007 that won't work.

Please update your profile and indicate your Excel version to take the guesswork out of the answering.

[Coaster]

I'm sorry I didn't remember that "little" detail lol

Excel 2007...I tried doing that but didn't get anywhere, as you said...what should I do?

[teylyn]

Coaster, unfortunately the Excel 2007 macro recorder ignores a lot of things to do with charting. It gets better again with Excel 2010.

I recorded the code below with 2010
- selected a range, first column has dates, third and second column has numbers
- created a chart (clustered column chart)
- edited each series and...

- defined new data ranges and data series title for two series
- defined new range for X axis (categories)

Hope you can glean something from that.

Please Login or Register  to view this content.

cheers

[Coaster]

Thank you very much, that's just what i needed!