« How do I make fractions on the computer?
CA Algebra I: Number Properties and Absolute Value »

How do I change the axis of multiple charts in an Excel Worksheet?

I have dozens of charts in one worksheet and I want to change the x and y axis so that they are all standard.. Is it possible to change them all at once or so you have to do one at a time?

You’re pretty much stuck doing them one at a time. If you know how to program in VBA, it is possible to do them all at once. It’s all a matter of how many you have to do. If it’s <10, you’ll use up less time reformatting each one individually. If you have a lot more than 10, it might be worth it to search the web for VBA code examples others have written to reformat charts en masse.

This entry was posted on Tuesday, September 1st, 2009 at 3:18 am and is filed under worksheet. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “How do I change the axis of multiple charts in an Excel Worksheet?”

  1. I_dun_doodit Says:
    September 1st, 2009 at 8:33 am

    You’re pretty much stuck doing them one at a time. If you know how to program in VBA, it is possible to do them all at once. It’s all a matter of how many you have to do. If it’s <10, you’ll use up less time reformatting each one individually. If you have a lot more than 10, it might be worth it to search the web for VBA code examples others have written to reformat charts en masse.
    References :

Leave a Reply