(Chart Help) I don't think you can do this but...

[NotASuperGenius]

...I thought I would ask.

I have a set of data by Week - Project - Project Hours - Project FTE. It looks something

8/8, Project Alpha, 392, 14
8/15, Project Alpha, 287, 11
8/22, Project Alpha, 404, 15

8/8, Project Beta, 45, 3
8/15, Project Beta, 70, 6
8/22, Project Beta, 72, 5

8/8, Project Gamma, 143, 4
8/15, Project Gamma, 92, 4
8/22, Project Gamma, 94, 5

I have created a clustered column chart that has hours on the y-axis and the projects clustered on the x-axis. I do the same thing for FTE in a separate chart. I would like to combine the two charts and include Hours and FTE in separate y-axises. Unfortunately I am having no luck figuring out how to set this up.

Thoughts?

 

[VoG]

This may help http://www.peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

 

[dave3009]

Hi

There is an option in Charts to add a secondary Yaxis, it should be under series options in PreXL07 if memory serves me right