You should be able to delete the secondary axis now. Repeat for the “Diff mid” series.Īdjust your secondary vertical axis so that the maximum is the same as your primary vertical axis. Then click on the “Copy” series and press Ctrl+1. My chart now looks like this.ĭelete the “Difference” series. 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 |