LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
lindy.coyle
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combination chart with three data ranges Joe Mac Charts and Charting in Excel 2 July 11th 05 11:00 PM
How can I make the graph omit blank cells in the data set? easy Charts and Charting in Excel 3 March 17th 05 02:48 PM
REPOST: How can I make the graph omit blank cells in the data set? easy Charts and Charting in Excel 2 March 17th 05 09:57 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"