Tip: If you are using Excel 2007 or 2010, right click the primary vertical axis in the chart and select the Format Axis to open the Format Axis dialog box, click Number in left bar, type 0 into the Format Code box and click the Add button, and close the dialog box.) In the Format Axis pane, type 160 into the Maximum box in the Bounds section, and in the Number group enter 0 into the Format Code box and click the Add button, and close the pane. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |