software

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.--
Boon8888
------------------------------------------------------------------------
Boon8888's Profile: www.excelforum.com/member.php...oamp;userid=30647
View this thread: www.excelforum.com/showthread...hreadid=505112
anyone have any ideas? or is it not possible?

Thanks--
Boon8888
------------------------------------------------------------------------
Boon8888's Profile: www.excelforum.com/member.php...oamp;userid=30647
View this thread: www.excelforum.com/showthread...hreadid=505112Hi Boon,

It would be rather tedious with 100 sheets, but one solution would be
to Copy a quot;donorquot; 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,
quot;Formats.quot;
- Repeat.

Read more at (watch the linewrap):

itstutorials.niu.edu/download...ck quide.pdf

hth,

LeAnne

Boon8888 wrote:

gt; Hi, just wondering if there is a quick solution to my problem. I have
gt; several charts, all virtually identical except for the data values in
gt; them, and i have one chart per sheet, and about 100 sheets.
gt;
gt; The problem is that some charts are positioned slightly different on
gt; their respective sheets then others on other sheets, although some are
gt; identical from sheet to sheet aswell. Just wondering if there is a
gt; quick way to select them all, line them up identically on each sheet,
gt; with all the same size/formating etc.?
gt;
gt; Thanks.
gt;
gt;