Bonus step: You can add a text box to the chart and type in “more this week” in it and place it above the line.Add a chart title, space out the grid lines and format the slope line. To do this, right click on the orange dots (slope series) and select “Change series chart type”. Change the slope series to “Scatter with straight line” type of chart.Now add this slope series to the scatter plot. (2) Enable the Fill & Line tab, and you can change the parameters to format the benchmark line freely, says line color, dash type, line width, etc. (1) Double click the benchmark line to enable the Format Error Bars pane. Note: You can easily format the benchmark line as you need:
Now the specified benchmark line is added in the selected chart. In the Add line to chart dialog, please check the Other values option, refer the cell containing the specified value or enter the specified value directly, and click the Ok button. Click Kutools > Charts > Add Line to Chart to enable this feature.ģ.
Select the chart you will add benchmark line for.Ģ. Full feature free trial 30-day, no credit card required! Get It Nowġ. Kutools for Excel- Includes more than 300 handy tools for Excel. to the currently selected chart in Excel. If you have Kutools for Excel installed, you can apply its Add Line to Chart feature to quickly add average line, benchmark line, target line, based line, etc. (2) This method can also add horizontal benchmark line in a line chart.Īdd horizontal benchmark/target/base line by Paste Special in Excel chart (1) This method can also add horizontal benchmark line in an area chart. Now you will see the benchmark line comes across all column data in the chart. In the Format Axis pane, under the Axis Options tab, please check the On tick marks option in the Axis Position section. Right click the horizontal X axis in the chart, and select Format Axis from the context menu. However, the benchmark line neither begins at the outside border of the first column, nor reaches the outside border of the last column.ħ. So far, the benchmark line has been added in the chart. Please specify the Chart Type of Benchmark series as Scatter with Straight Lines, uncheck the Secondary Axis option behind it, and then click the OK button. Now the Change Chart Type dialog comes out. In the chart, right click the new Benchmark series, and select Change Series Chart Type from the context menu. Now the benchmark data has been added as a new data series in the activated chart.ĥ. In the opening Paste Special dialog, please check the New Series option, the Columns option, the Series Names in First Row checkbox, the Categories (X Labels) in First Column checkbox, and then click the OK button. Click to activate the original chart, and then click Home > Paste > Paste Special. Say goodbye to terrible VBA and formulas!ģ.
0 kommentar(er)
