Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Chart Comparison
I'm having difficulties setting up some comparison charts. I have 2 groups I
want to compare (Planned and Actual work days) and (Planned and Actual review days). Heres the way the data is layed out: Production Development Days Difference __________________________________________________ ______ Planned Co Review Days 864 33 Actaul Co Review Days 897 Planned Co Development Days 585 327 Actaul Co Development Days 912 Can you point me in the right direction for setting up a comparison of Review Days (planned and actual) and Development Days (planned and actual)? Everytime I mess around with the wizard I get 4 bars spaced evenly appart. I would really like to pair them up so the Planned reveiw and Actaul review are nudged up against one another (likewise with Develpment) to clearly illustrate the differnce between each pair. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Chart Comparison
You need to rearrange your data:
Plan Actual Review 864 897 Devel. 585 912 Now construct a clustered column chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "SuperRy" wrote in message ... I'm having difficulties setting up some comparison charts. I have 2 groups I want to compare (Planned and Actual work days) and (Planned and Actual review days). Heres the way the data is layed out: Production Development Days Difference __________________________________________________ ______ Planned Co Review Days 864 33 Actaul Co Review Days 897 Planned Co Development Days 585 327 Actaul Co Development Days 912 Can you point me in the right direction for setting up a comparison of Review Days (planned and actual) and Development Days (planned and actual)? Everytime I mess around with the wizard I get 4 bars spaced evenly appart. I would really like to pair them up so the Planned reveiw and Actaul review are nudged up against one another (likewise with Develpment) to clearly illustrate the differnce between each pair. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ow to create comparison chart using text as value data? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |