Bar Chart Comparison

G

Guest

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.
 
J

Jon Peltier

You need to rearrange your data:

Plan Actual
Review 864 897
Devel. 585 912

Now construct a clustered column chart.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top