LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 3rd 06, 01:06 PM posted to microsoft.public.excel.charting
Posts: n/a
Default 2 different types of data sets displayed on 1 graph

I have a district that I wish to show performance (sales)in the months from
July to November and comapred this with 2004 and 2005. Now on top of this I
want to display on the same graph a second variable say number of customers
for each month and each year, in order to bring some greater relevance to the
static bar graphs that I propose doing for the first part.

So I have been assisted on this discussion group to have a bar graph that is
set up with the months as rows and the 2004 and 2005 as columns for the sales
data BUT how do I now display the second variable 'number of customers' as
say a line graph over the 2004 and 2005 bar graph sets?

Can I then add 11 more districts to the same graph or is that becoming too
messy / congested as a graph?

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
How do I copy a graph and use the data in the new worksheet? Brendanluc Charts and Charting in Excel 9 February 9th 08 07:49 AM
adding data table with different data to a graph ratio Charts and Charting in Excel 1 June 17th 05 05:24 PM
How can I get 7.3 million data pts on one line graph? tobesus Excel Discussion (Misc queries) 2 April 22nd 05 01:16 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
How do I "index" data in a line graph? ShirleyJL Charts and Charting in Excel 2 January 10th 05 11:06 PM

All times are GMT +1. The time now is 06:37 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017