![]() This example teaches you how to change the axis type. The rainfall is plotted on the secondary vertical axis.įind more details about our Microsoft Office training London, UK or our Microsoft Office training in the Wiltshire, Dorset and Hampshire areas.įor more details about our Microsoft Office training Sydney, Australia, please visit. Most chart types have two axes: a horizontal axis (or x-axis) and a vertical axis (or y-axis). Select Secondary Axis from the Series Options section. ![]() Select the line, then on the Chart Tools Layout tab, click Format Selection the Format Data Series dialog box opens. Be sure to include all data points and the labels. Click and drag to highlight all the data you want to graph. Each data point should be contained in an individual cell with rows and columns that are labeled. I would now like rainfall to be shown on a secondary vertical axis. Adding a Second Y Axis 1 Create a spreadsheet with your data. On the Chart Tools Design tab, click Change Chart Type, select one of the line chart types, then click OK. I now decide to have a line v column chart.Ĭlicking one column in the chart selects all columns in that series.
0 Comments
Leave a Reply. |