This example uses a combo chart based on a column chart to plot daily sales and an XY scatter chart to plot the target. The trick is to plot just one point in the XY scatter chart, then use error bars to create a continuous line that extends across the entire plot area.

Data

The data used to build this chart is shown below:

How to create this chart

From this point, you have the basic column chart with edge-to-edge target line. You can now format the chart as you like: add a title, set color and width for the target sales line, add data labels, etc. Note: I learned the error bar approach from Excel chart guru Jon Peltier.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Combo chart example Column chart with target line - 95Combo chart example Column chart with target line - 6Combo chart example Column chart with target line - 49Combo chart example Column chart with target line - 15Combo chart example Column chart with target line - 22Combo chart example Column chart with target line - 61Combo chart example Column chart with target line - 89Combo chart example Column chart with target line - 73Combo chart example Column chart with target line - 79Combo chart example Column chart with target line - 61Combo chart example Column chart with target line - 45Combo chart example Column chart with target line - 76Combo chart example Column chart with target line - 78Combo chart example Column chart with target line - 35Combo chart example Column chart with target line - 3