To add data, click the chart, click the Edit Chart Data button near the chart, then enter your data in the Chart Data editor.Optional: Next to 'Apply to,' choose the data series you want to appear on the right axis.Īdd a column, bar, line, area, pie, or donut chart.Double-click the chart you want to change.Switch this data series from your primary Y axis to your secondary Y axis. On your computer, open a spreadsheet in Google Sheets. Gather your data into a spreadsheet in Excel.People also ask, how do I add a second Y axis in Google Sheets? Close the Chart Data editor when you're done. Click a row or column button in the top-right corner of the Chart Data editor. The right click option is no longer available in Keynote 6.īeside above, how do you edit data in Keynote? Click the chart, then click the Edit Chart Data button. To label your graphs x- and y-axes, select Axis Titles from the Chart Layout tab, and then select how youd like your Horizontal Axis Title and Vertical. To do this in in Excel Mac 2011, after you have plotted all your data series in a chart, right click on a single series, select Format Data Series > Axis > Plot Series on Secondary Axis.
Similarly, you may ask, how do I add a second Y axis in Keynote?