ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Combination chart - Line - Column on 2 Axes (https://www.excelbanter.com/charts-charting-excel/119157-combination-chart-line-column-2-axes.html)

Debbie

Combination chart - Line - Column on 2 Axes
 
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

Combination chart - Line - Column on 2 Axes
 
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 wrote:
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


Debbie

Combination chart - Line - Column on 2 Axes
 
Worked great! Thanks so much!

Debbie

"Andy Pope" wrote:

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 wrote:
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




All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com