Line and Bar chart

[Jtucker10278]

Im trying to create a chart that has 2 different data types?

Along the bottom axis is Time e.g. Week 1, Week 2, Week 3 ect.
and along the left side axis I have the number of panels built

This works great as a line chart and usually have between 350 to 600 panels built each week.

What I would like to do is to add a bar chart to the line chart that shows number of panel builders for each week.

so for example week 1 I had 8 guys building panels and they built a total of 380 panels.

In week 2 I had 11 guys building for a total of 450 panels.

the problem is that a chart that shows a difference of 380 to 450 is not going to show 8 or 11 of anything its to small of a number.

so is there a way to scale that up? or is there some other cleaver way to show that data

thanks

 

[mole999]

plot on the secondary axis (via a right click menu)