3 charts per page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I put 3 charts on one page for printing? I don't want the excel data; just the charts.
 
The easiest (only?) way I can think of is to make them embedded objects
in a worksheet (or a chart sheet).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Hi Lulu,
You can put more that one chart on a chart sheet - the info is somewhere in
one of John Walkenbach's book. I looked quickly in 2 but could not find the
details.
But here is a work around.

1) Make the three charts as embedded (on a worksheet)
2) To be safe make copes of each on the same worksheet (you can use
Copy&Paste or hold CTRL and drag a chart to make a copy.)
3) Use View|Toolbars to get Drawing toolbar visible
4) Make a large rectangle
5) Drag the three charts into the rectangle; get them lined up as needed
6) Hold down SHIFT, click the rectangle and the three charts (watch for
hollow circles on each object); right click inside the drawing; use Group
and group the items.
7) Use one set of data to make a chart on a chart sheet
8) Go back to your drawing object; use Copy tool; open Chartsheet; use Paste
tool. Use the handles to enlarge the drawing to fill the chartsheet; check
with Print Preview
The chartsheet has your three charts.
If needed; right click on the rectangle in the Chartsheet, use Format and
specify Line Noline. This removes the 'box' around your three charts
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address
Lulu said:
How can I put 3 charts on one page for printing? I don't want the excel
Click to expand...
data; just the charts.
 
Back
Top