I also added the word “Benchmark” to the line by adding a data label to just the left most point. (This is a good time for me to mention that if I ever open a pub for data nerds, I’m going to call it The Benchmark Bar.) You can do this in 2010, too, just click on the benchmark bars and then click the Change Chart Type button in your Layout tab and select a line graph. In Excel 2013, I right-click on the orange benchmark bars and click Change Chart Type and then choose Line. Now it’s time to move that benchmark data from bars to a line. It’ll look like this, but don’t freak out: In *that* dialogue box, select your Benchmark data. In that box that pops up, click the Add button to add a new series. Then right-click on the graph and click Select Data. Highlight the group names and their data and insert a simple bar graph: I have my data and I have the benchmark value listed next to each. Here’s how to make one right inside Excel. Adding a benchmark line to a graph gives loads of context for the viewer.
0 kommentar(er)
