[RESOLVED] [Excel 2003] Printing with Charts

[Torc]

I have a spreadsheet which contains is used to summarise information,
and presents it graphically using three charts.
i.e.

A B
C D

Where A is my data and B, C & D are the three charts.

At present when I use Print I get part of a chart on one page, and another part on another page.

Given that I cannot adjust the layout of the charts is there any way to indicate that if a chart is printed that it must be all be on the same page.

[westconn1]

one way would be to print the charts separately then they would each print on a new page
otherwise you would need to manipulate the charts position temporarily, or manipulate the page setup

[Torc]

Hi westconn,

Apologies for taking so long to get back to you.

Unfortunately as I stated I am unable to adjust the layout of the charts, and
am hoping there is some way to set the charts so they print out without
having part of the chart on one page, and another part on another page.

[westconn1]

did you try to change the page setup, or no use?

[Torc]

Yes, I have modified that. Unfortunately it did not work too well.

Although I can Insert Page Breaks this is only a temporary solution, as I would need to re-configure the page breaks if the data on the charts changed significantly.

I have come up with a possible solution, I used record Macro to find the code to move a chart.

ActiveSheet.Shapes("Chart 3").IncrementLeft 66.75
ActiveSheet.Shapes("Chart 3").IncrementTop 2.25

And to adjust its hieght and width.

ActiveSheet.Shapes("Chart 3").ScaleWidth 0.91, msoFalse, msoScaleFromTopLeft
ActiveSheet.Shapes("Chart 3").ScaleHeight 0.91, msoFalse, msoScaleFromTopLeft

So now I just need to find the Positions of a chart relative to the cells on the
Worksheet; and what Page a cell in the worksheet would be pritned on.

For the time being I will mark this thread as resolved.

Many thanks.