Printing many charts on one page

J

Johnb

I need to summarise 6 different groups of data from a
single worksheet with about 10,000 rows. Using 6
PivotTables I create a summary for each group of data. I
now need to create 6 Bar Charts and print them on a single
sheet of paper in portrait. It's automating the printing
of the charts on a single sheet that I having difficulty
with. Comments most welcome.
 
M

Mike Woodhouse

Johnb said:
I need to summarise 6 different groups of data from a
single worksheet with about 10,000 rows. Using 6
PivotTables I create a summary for each group of data. I
now need to create 6 Bar Charts and print them on a single
sheet of paper in portrait. It's automating the printing
of the charts on a single sheet that I having difficulty
with. Comments most welcome.
Click to expand...

If the charts are created as Chart Sheets then as far as I can see,
without a fair chunk of VB code (and quite possibly even with it)
you're stuck.

If you can get your charts into a worksheet then it should be fairly
simple matter to arrange the charts in a suitable fashion. The trick
is to persuade Excel to let you create your chart "as object in" a
worksheet rather than a chart shet in its own right. I found that by
right-clicking on the Chart Sheet I could select "Location", which let
me get the chart moved.

HTH,

Mike
 
J

Jon Peltier

The default Location for regular charts is "as object in" the active
sheet, but for pivot charts it's as a chart sheet.

When you change the location of the charts to a worksheet (use a new
clean worksheet), you can then arrange the charts along cell borders by
holding the Alt key while moving and resizing the charts. This is a poor
man's tool for making the charts similar in size.

- Jon
 
N

Nicky

Hi John

It is possible to put more than 1 chart on a single chart sheet, bu
not (I think) pivot charts. So if you don't need to use pivot char
format (you can still use data from a pivot table as the source of you
data) then the attached might be a solution

Attachment filename: multiple chart.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=42145
 
Top