Ask Your Question

how to set the "line" data on a column and line chart

asked 2018-10-04 21:07:10 +0200

BigWorm gravatar image

Creating a column and line chart. I have all the columns set up but the last column needs to be the line on the secondary Y axis. How do I get the information to change from a column to a line on the other axis.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-05 21:21:06 +0200

erAck gravatar image

Double click the chart to place it into edit mode, then click the line or from the toolbar's listbox select the Data Series 'your last column', then use Format -> Format Selection... and on the Options page Align Data Series to Secondary Y axis.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-04 21:07:10 +0200

Seen: 34 times

Last updated: Oct 05 '18