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
|
|||
|
|||
Is this possible with Excel Chart?
Hi,
I am looking to see if the following is possible? I have 20 departments with 4 regional managers looking after them. I have created 4 separate bar charts (laid sideways) on one excel sheet for each regional manager showing his departments figures. This works fine. I have now been asked to combine all four regional managers charts into one big chart. Each manager has a section that then needs to include their departments. example: Title: Area Managers League AREAMANAGER1: Town1 Results Town2 Results etc AREAMANAGER2: Town1 Results Town2 Results etc AREAMANAGER3: Town1 Results Town2 Results etc AREAMANAGER4: Town1 Results Town2 Results etc Is this possible, or something simalar, can you please advise or point to reference information. Thanks Darrell... --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Darrell -
There are a few things that come to mind, depending on what you want to show. This is the most likely, based on my interpretation of your problem statement. I assume town 1 for manager 1 is not the same as town 1 for manager 1. Arrange the data this way: Result AreaManager1 Town1 (data) Town2 (data) Town3 (data) Town4 (data) AreaManager2 Town1 (data) Town2 (data) Town3 (data) Town4 (data) AreaManager3 Town1 (data) Town2 (data) Town3 (data) Town4 (data) AreaManager4 Town1 (data) Town2 (data) Town3 (data) Town4 (data) The cells above the AreaManager1 and the Town1 cells should be blank. The three cells below each AreaManagerX should also be blank. Select this whole range and make a bar chart. Double click on the X axis (the vertical axis with the AreaManager and Town labels), and on the Scale tab, check the Categories in Reverse Order and Value Axis Crosses at Maximum Category boxes. If you want each manager's data to be formatted differently, the easiest way to do it is with this data arrangement: Manager1 Manager2 Manager3 Manager4 AreaManager1 Town1 (data) Town2 (data) Town3 (data) Town4 (data) AreaManager2 Town1 (data) Town2 (data) Town3 (data) Town4 (data) AreaManager3 Town1 (data) Town2 (data) Town3 (data) Town4 (data) AreaManager4 Town1 (data) Town2 (data) Town3 (data) Town4 (data) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ q582gmzhi wrote: Hi, I am looking to see if the following is possible? I have 20 departments with 4 regional managers looking after them. I have created 4 separate bar charts (laid sideways) on one excel sheet for each regional manager showing his departments figures. This works fine. I have now been asked to combine all four regional managers charts into one big chart. Each manager has a section that then needs to include their departments. example: Title: Area Managers League AREAMANAGER1: Town1 Results Town2 Results etc AREAMANAGER2: Town1 Results Town2 Results etc AREAMANAGER3: Town1 Results Town2 Results etc AREAMANAGER4: Town1 Results Town2 Results etc Is this possible, or something simalar, can you please advise or point to reference information. Thanks Darrell... --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |
Changing chart background color in Excel 97 SR 2 | whayface | Charts and Charting | 4 | May 2nd, 2004 12:31 AM |
Large Amounts of Data in Excel Chart | Nikki | Charts and Charting | 1 | April 17th, 2004 09:37 AM |
Add-In for Pivot chart in MS Excel 97 | Sumit Walia | Charts and Charting | 4 | November 7th, 2003 08:12 PM |