Usually in order to characterize plotted data more completely, it helps to add a target line to your chart. There are a number of ways to do this in an Excel chart. If your chart is a column chart, you can add another column series, you can add a line series that spans the middle of the first column to the middle of the last, you can add an XY series that spans the entire chart, or you can add an XY point with an error bar that spans the chart.
We are plotting how five employees of our widget factory perform against their target of 22 widgets. Here is the data; ignore the extra data beyond column C for now.
A plain chart of the employees’ performance is shown here. This column chart was created using the data in A1:B6. [Read more…] about Add a Target Line