quick charting question for similar charts on multiple sheets

  • Thread starter Thread starter Boon8888
  • Start date Start date
B

Boon8888

Hi, just wondering if there is a quick solution to my problem. I have
several charts, all virtually identical except for the data values in
them, and i have one chart per sheet, and about 100 sheets.

The problem is that some charts are positioned slightly different on
their respective sheets then others on other sheets, although some are
identical from sheet to sheet aswell. Just wondering if there is a
quick way to select them all, line them up identically on each sheet,
with all the same size/formating etc.?

Thanks.
 
Hi Boon,

It would be rather tedious with 100+ sheets, but one solution would be
to Copy a "donor" chart, then Paste Special the format of the donor
chart to the recipient chart(s):

- Arrange all chart objects in the donor chart the way you want.
- Select the chart area of the donor chart, right-click, Copy.
- Select the chart area of the recipient chart, Edit, Paste Special,
"Formats."
- Repeat.

Read more at (watch the linewrap):

http://itstutorials.niu.edu/downloa...ting & linking/excel charting quick quide.pdf

hth,

LeAnne
 
Back
Top