![]() 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. Select Secondary Axis from the Series Options section. Click the Format tab In the current selection group, select the series for which you want to add a. Select the line, then on the Chart Tools Layout tab, click Format Selection the Format Data Series dialog box opens. Select the data and insert the chart Click the chart. I would now like rainfall to be shown on a secondary vertical axis. On the Chart Tools Design tab, click Change Chart Type, select one of the line chart types, then click OK. Under 'Frame & Axes', select 'Plot 2 Y axes'. With the graph in view, choose 'Change.Axes: Range and Ticks'. Under 'Plot on Y Axis', choose 'Left Y axis' or 'Right Y axis'. This is done in the 'Format Symbols and Lines' dialog for XY graphs, otherwise in the 'Format Bars' or 'Format Columns' dialog. I now decide to have a line v column chart.Ĭlicking one column in the chart selects all columns in that series. Assign one or more data sets to the right axis.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |