Creating a summary chart using data from multiple sheets

[JMooman]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm looking for any guidance you might have in creating a single chart that allows me to plot data from multiple sheets in the same excel file.

I've arranged the data on each individual sheet so that the items I am looking to plot are in the same cells from sheet to sheet (basically each sheet corresponds to a particular months expenses).

I'd like to place a chart on a separate sheet that allows me to plot particular categories (ie, cells) from each of the monthly sheets. Giving me a chart of my monthly expenses.

Can I create a chart that draws directly from the sheets or do I need to get the data that I wish to chart pasted on the sheet where the chart will reside?

 

[Laroche J]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm looking for any guidance you might have in creating a single chart that
allows me to plot data from multiple sheets in the same excel file.

I've arranged the data on each individual sheet so that the items I am looking
to plot are in the same cells from sheet to sheet (basically each sheet
corresponds to a particular months expenses).

I'd like to place a chart on a separate sheet that allows me to plot
particular categories (ie, cells) from each of the monthly sheets. Giving me a
chart of my monthly expenses.

Can I create a chart that draws directly from the sheets or do I need to get
the data that I wish to chart pasted on the sheet where the chart will reside?

A chart can be on its own chart sheet, that's why when you create a chart
Excel asks where you want it to appear (with data or alone). After the fact
you can also move a chart to its own sheet with Chart, Location.

Create the chart on a separate chart sheet using data from the first data
sheet. Then go to Chart, Source Data, Series tab, and add the source range
for the other months, one per one. I find it easier to do copy and paste for
the Name and Values fields, just changing the name of the sheet after
pasting. You may have to collapse the field with the pyramid in order to
paste.

If you want similar charts for different expenses, make copies of the first
one (after perfectly formatting it to your need), go back to Chart, Source
Data, Series tab, and change the location of your data sources.

JL
Mac OS X 10.4.11
Office v.X 10.1.9