I changed the width, made them dotted and changed the colour to match the target line. Your chart should update as shown below:įormat the lines as you wish by clicking on them and pressing Ctrl+1. Step 3: Format the chart Add the drop linesĬlick on the “Target” line (the top most line in the chart), then click on chart tools > Layout > Lines > High-low lines. Highlight the whole table and click on Insert > Chart > Line > 2-D Line > LineĪ chart like the one below should appear:ĭelete the gridlines and legend. In the “Difference” column, in cell E2, type in the following calculation:Ĭopy and paste the calculations to the last row in the table. In the Diff mid column, in cell D2, type in the following calculation: In the “Copy” column simply copy the data from the actual column. Your original data table with the actual and target columns will probably look something similar to the one below:Īdd three extra columns in between your actual and target columns and label them “Copy”, “Diff mid” and “Difference”: You can download the sample worksheet here. I promised I would show the “how to” and here it is. If you are a regular reader you will have seen an example of this chart last week in this post. That being said, you can also show this with line charts if you have a lot of data points over time for example. There are of course lots of ways of doing this, my favourite being bullet charts. Sometimes it is important to know the performance against a target.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |