#1   Report Post  
YOOPER Mike
 
Posts: n/a
Default Multiple charts

I need to have 3 different charts on one page; 11x17 sheet.
How can I do this???
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Mike -

You can embed charts in worksheets or chart sheets. I think a worksheet would be
easiest.

With the brand new worksheet active, go to Page Setup on the File menu. Pick the
orientation and paper size on the Page tab. I can't get 11 x 17 in my page setup; I
wonder if that's just because my default printer won't accommodate that size.

When you make your charts, in step 4 of the chart wizard, for Location, choose the
As Object In option, and select this page you've set up.

You can use the cell borders to line up your charts, if you hold the Alt key while
moving and sizing the charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


YOOPER Mike wrote:

I need to have 3 different charts on one page; 11x17 sheet.
How can I do this???


  #3   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

If the X axis labels are the same, you could use one of these charts.

http://www.peltiertech.com/Excel/Cha....html#StakLine

http://www.peltiertech.com/Excel/Cha...kedCharts.html

They are a bit confusing at first, but they are slick looking when they are
done. I've done several for a report recently and they really get the
point across with a minimum of space.

"YOOPER Mike" <YOOPER wrote in message
...
I need to have 3 different charts on one page; 11x17 sheet.
How can I do this???



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem drawing lines on charts Susan Lambert Charts and Charting in Excel 7 December 13th 04 09:29 AM
Log charts Robert Peirce Charts and Charting in Excel 2 December 9th 04 10:48 PM
Odd problem with charts... narrow! rci Charts and Charting in Excel 0 December 9th 04 06:42 PM
displaying several charts, one at the time Tony Charts and Charting in Excel 2 December 5th 04 10:10 PM
pie charts - how to include "zero" fields on Legends Doug VanOrnum Charts and Charting in Excel 0 November 30th 04 05:49 PM


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"