Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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
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
ow to create comparison chart using text as value data? deejohn525 Charts and Charting in Excel 1 April 27th 06 12:51 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 08:21 PM.

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

About Us

"It's about Microsoft Excel"