lack of chart uniformity

[Guest]

Hello,

I want all of my charts to have the exact same formatting. All of the data has the same range on the chart, the same number of variables, and they also have the same axis and titles as defined in a user-defined chart. However, each time I make a chart for each worksheet, each chart comes out different. Meaning, the font size of the axis or title bars will vary or the alignment of these bars will also vary. What should I do to make everything uniform without having to reformat every single chart each time I make a change?

 

[Jon Peltier]

Aja -

I find that the features in a chart that I haven't reformatted are
likely to suffer from Excel's own reformatting. So I make sure to change
all things, which isn't hard, since I like my own way better. But I make
one chart first, fix it up, then put other data on copies of the first
chart. If you already have other charts that you want to look like the
first, copy the first, then from the Edit menu, choose Paste Special,
and choose Formats. This applies all of the formatting, including the
text in the axis and chart titles, from the copied chart to the pasted
chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______