Graphing data from multiple worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

matta25 - 12 Feb 2008 16:38 GMT

Hello,
I have four work sheets that has data for the last four years. (one
sheet for each year) I made a new worksheet and want to create a Line Graph
that will graph the data from the oldest year to the current year. Excel is
not letting me select multiple work sheets. Can this be done?

Thanks
Matt

Reply to this Message

Bob I - 12 Feb 2008 17:02 GMT

Not in one series. Either multiple series, OR reference ALL the data on
multiple sheets from a single sheet and use that sheet for your series.

> Hello,
> I have four work sheets that has data for the last four years. (one
[quoted text clipped - 4 lines]
> Thanks
> Matt

Reply to this Message

JP - 12 Feb 2008 20:16 GMT

In the Pivot Table Wizard, Step 1, choose "Multiple consolidation
ranges". Keep in mind the ranges have to have the same headers, and
have no blank rows/empty columns in the middle of the data.

Let us know if it works.

(ps- I tested with some dummy data and it worked)

HTH,
JP

> Hello,
> I have four work sheets that has data for the last four years. (one
[quoted text clipped - 4 lines]
> Thanks
> Matt

Reply to this Message