Combination chart - Line - Column on 2 Axes

[Debbie]

Hello!

I am trying to create a combination chart that has bars and a line. The
bars should all relate to one axis while the line should relate to the
secondary axis. The problem is that when I make the chart, it relegates one
of my bars to a line. I can change the axis to the primary where it should
be but it is a line, not a bar. I have also tried making a column only chart
and add in my line and secondary axis but to no avail. As soon as I put in
the secondary axis, Excel converts one of my bars to a line.

Any input would be a great help!

Thanks,
Debbie

 

[Andy Pope]

Hi,

Make you own combination rather than using those offered by the wizard.
Create a column chart based on all the data. Select the series that you
want to be a line chart. Right click and choose Chart Type. Pick
required line chart type. Now double click the line series and on the
Axis tab set the series to the secondary axis.

Cheers
Andy

 

[Debbie]

Worked great! Thanks so much!

Debbie

Hi,

Make you own combination rather than using those offered by the wizard.
Create a column chart based on all the data. Select the series that you
want to be a line chart. Right click and choose Chart Type. Pick
required line chart type. Now double click the line series and on the
Axis tab set the series to the secondary axis.

Cheers
Andy