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.
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.