Printing many charts on one page

  • Thread starter Thread starter Johnb
  • Start date Start date
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.
 
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
 
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
 
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
 
Back
Top