ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dashboard 1 page w/multiple graphs (https://www.excelbanter.com/excel-discussion-misc-queries/168373-dashboard-1-page-w-multiple-graphs.html)

Mac

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?

Bob Phillips

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?




Jon Peltier

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?





All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com