Thread: Specifying the format of a series i.e line or bar

Hi,

I am currently trying to create a chart from the following data:

Example1.xls

The problem is that I want 'Cost' and 'Cumulative Cost' on the same axis, and as lines. I want 'Quantity' to be on the primary axis, in bar format. When i try to create the graph I can only get what is shown in the example i.e cost is displayed as bars instead of a line.

Can anyone help me to set this up the way that I need to?

Thanks,

Jonny.

First change charttype to column.

Change Series 2 and 3 to secondary axis
change series 2 and 3 chart type to line