six. Today the change Chart Form of dialog comes out. Excite specify the fresh new Chart Form of Standard collection as the Spread having Straight Lines, uncheck the brand new Supplementary Axis choice about they, and click the new Ok key. Select screenshot:
Yet, the latest standard range has been added on the graph. But not, the standard range none starts at external edging of very first line, nor are at the outside border of your own history column.
eight. Right click on the horizontal X axis from the graph, and choose Style Axis about framework menu. Come across screenshot:
8. Regarding Style Axis pane, under the Axis Selection tab, please browse the On the tick scratches choice regarding the Axis Status part. Discover screenshot:
Put lateral benchazing device
When you have Kutools getting Prosper strung, you could incorporate their Add Range to Chart feature so you’re able to quickly incorporate average line, benchmark line, target line, created line, etcetera. Читать далее