How to add a baseline in excel line graph

The problem with this process is that the line won’t be fixed in the position if you.

Author. 4. Now it's time to neaten up the axes. May 16, 2023 · Step 4: Add Data to the Graph. . . " Press the "Add" button below "Legend Entries (Series). Step 3.

. . . In the new window that appears, click the tab called All Charts near the top and then click Combo: Once you click OK, a bar graph with a target value will. . = IF ( MAX ( [Sales])= [@Sales],1,""). One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value.

.

In the new window that appears, click the tab called All Charts near the top and then click Combo: Once you click OK, a bar graph with a target value will. 2: Select the table and insert a Combo Chart: Select the entire table, including the supporting column and insert a combo chart. To create a chart with a baseline, you'll need two sets of data: one for the actual values and one for the baseline.

With the source data selected, go to the Insert tab > Charts group, click the Insert Line or Area Chart icon and choose one of the available graph types.

Use the Chart Styles button to quickly change the color or style of the chart.