![]() |
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? |
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? |
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