How do I do multiple charts on the same page? Is there a merge fu

[Guest]

I have several charts to on students and want them to be on the same page.
How do I do this? Also, is there a merge application within Excel that would
enable me to merge names of students into the graphs without doing each one
separately?

 

[Randy Lefferts]

Not sure if this what you are looking for but if you are
referring to having multiple charts on the same
worksheet, you can accomplish this by copying the
original chart and pasting it into your "master"
worksheet.

Or you can simply create each chart on the same page.
Set the data source of the chart to the data on
the "other" page that contains the data. Use the chart
wizard and as you progress through the screens, you will
be asked to specify the data. Point to the data range.
Also, once you work through the various dialog screens,
you will be asked where you want the chart to be placed;
in the same sheet as the data or in another sheet. Simply
choose another sheet.

HTH

 

[NeilM]

* You have two charts in a worksheet.
* Right click on the first. On the menu, click
on "Location...". Place chart "as new sheet" (Chart1). OK.
* Repeat for second chart. This is the important step.
Again select: Chart1 .
* You will see the message "This sheet already exists.
Place chart embedded in existing sheet?" Answer YES.
* Done.