Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mac Mac is offline
external usenet poster
 
Posts: 213
Default Dashboard 1 page w/multiple graphs

Is it possible to have 5-7 grahps within one sheet.

sheet 1 with 10 lines of data y-axis is the dates from Jan to Dec and x-axis
the data.
sheet 2 the same as above
sheet 3 the same as above

Is it possible to place all 3 graphs on 1 page?
If so, how?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default Dashboard 1 page w/multiple graphs

Yes of course. When you create the chart, on the last page of the wizard,
you can specify which sheet it goes on.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mac" wrote in message
...
Is it possible to have 5-7 grahps within one sheet.

sheet 1 with 10 lines of data y-axis is the dates from Jan to Dec and
x-axis
the data.
sheet 2 the same as above
sheet 3 the same as above

Is it possible to place all 3 graphs on 1 page?
If so, how?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Dashboard 1 page w/multiple graphs

When you create the charts, create them as objects in another sheet. This is
the default when using the chart wizard. In step 4 of the chart wizard, you
can select a particular sheet, otherwise the active sheet is used. You could
define this sheet in the chart wizard for all of your charts, so they end up
on the same page, or you could create the charts as usual, then copy or cut
each chart and paste it onto the desired sheet.

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


"Mac" wrote in message
...
Is it possible to have 5-7 grahps within one sheet.

sheet 1 with 10 lines of data y-axis is the dates from Jan to Dec and
x-axis
the data.
sheet 2 the same as above
sheet 3 the same as above

Is it possible to place all 3 graphs on 1 page?
If so, how?



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
Two Graphs Same Page Vinny Charts and Charting in Excel 1 February 28th 07 09:59 AM
Updating multiple graphs in multiple worksheets at the same time J@Y Excel Discussion (Misc queries) 3 February 1st 07 03:30 AM
Multiple pie graphs on single page cgtToronto Excel Discussion (Misc queries) 0 January 26th 07 02:50 PM
How do I set up multiple graphs/charts on one page? Daniel Excel Discussion (Misc queries) 2 May 20th 06 02:41 PM
How can I get several graphs on one Excel page? Bethany Charts and Charting in Excel 4 November 13th 05 01:36 AM


All times are GMT +1. The time now is 08:48 AM.

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"