Home |
Search |
Today's Posts |
#1
|
|||
|
|||
graph multiple data ranges
I have two worksheets with the same column/row headings, just different data
for different years. I have created bar graphs for each individual year to see where income, etc fluctuated w/in the year. However, I'd like to create a bar graph on a different worksheet that would show, for example Oct 2004 through Oct 2005, so we see the entire year's fluctuations and can compare the current month to the same month last year. It seems like it should be simple, but I can't figure it out. Is it possible? Thanks! Lindy |
#2
|
|||
|
|||
graph multiple data ranges
Does this help?
http://peltiertech.com/Excel/ChartsH...iffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ lindy.coyle wrote: I have two worksheets with the same column/row headings, just different data for different years. I have created bar graphs for each individual year to see where income, etc fluctuated w/in the year. However, I'd like to create a bar graph on a different worksheet that would show, for example Oct 2004 through Oct 2005, so we see the entire year's fluctuations and can compare the current month to the same month last year. It seems like it should be simple, but I can't figure it out. Is it possible? Thanks! Lindy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination chart with three data ranges | Charts and Charting in Excel | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |