Multiple charts at the same time

[Guest]

I have data for several chapters which i would like to create charts for. However, one chart at a time is to cumbersome. How can I create multiple charts for the different chapters and personalize them at the same time?

 

[Tushar Mehta]

One possible way is to record a macro while creating the first chart.
Then, customize the XL generated code to work with the 'active sheet'
rather than the hardcoded sheet name. If you are new to VBA
programming, turn on the macro recorder (Tools | Macro > Record new
macro...), create the chart, turn off the recorder, and share the
created code (in the text of the message, not as an attachment).
Someone should be able to help you from there.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

You could make one chart the way you want them all to be, then save it
as a custom type. With the chart selected, choose Chart Type from the
Chart menu, click on the Custom Types tab, click on User Defined near
the bottom, and Add below that. Enter a name and description for your
chart. You can apply this chart type to an existing chart or to a new
chart as you're making it.

- Jon