![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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? Mike Can I then add 11 more districts to the same graph or is that becoming too messy / congested as a graph? Mike |
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
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 06: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 05:55 PM |
| How do I "index" data in a line graph? | ShirleyJL | Charts and Charting in Excel | 2 | January 10th 05 10:06 PM |