In the chart, right click the secondary vertical axis (the right one) and select Format Axis from the right-clicking menu.ĥ. In the opening Format Data Series pane/dialog box, check the Secondary Axis option, and then close the pane or dialog box.Ĥ. In the chart, right click the below series, and then select the Format Data Series from the right-clicking menu.ģ. Select the source data, and add a line chart with clicking the Insert Line or Area Chart (or Line)> Line on the Insert tab.Ģ. Supposing there are two data series in the source data as below screen shot shown, we can easily add a chart and break the chart axis with adding a secondary axis in the chart.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |