Line Bar Charts in Excel

[funkylad20]

I am wanting to create a barc hart with three values on in (high figures) and a LINE chart to go ver the top (which has very small figures).

Can anybody help?

[ABerrant]

Are you asking how to create the chart or how to turn small figures into a comparable magnitude as the high figures (e.g. such as by multiplying the small figures to scale them up)?

[scotman]

I don't believe you can overlay charts in Excel. Someone else may know better though.

[dundurn]

I think you'll find that if you click on the particular data you're trying to show on the line graph you can select the type of graph to use i.e. line and then selecting the axis tab will allow you to show this on a separate scale

[dundurn]

This works with a combined Column and Line chart but not with a Bar and Line chart.