Here is a real quick tip that you may want to learn when using Excel. This tutorial will help you apply this technique to your charts to make them more readable.
Here is what a standard chart and chart legend may look like. Notice that the color blocks in the Excel Chart legend are small squares.
How would you like the color blocks to be larger and more readable in your Dashboards?
How can we do this?
The Breakdown
1) Create your chart with an additional data series.
2) Change the data series to a line chart.
3) Change the Line Color to white.
4) Delete the data for the dummy line series.
Step-by-Step Tutorial
1) Create a Column Chart with an additional series.
2) Change the blank series to a line chart. Don’t worry that you don’t’ see it, it is still there, just the line is only one point long. You will also notice that you now have longer color blocks in the legend from a box to a rectangle.
3) Now change the color of the line to the same as the background color. In this case change the line color to white.
4) Now delete the dummy series data so that it does not appear in the legend.
Now you can wow and amaze your co-workers and executives since your dashboard will have non-standard legend entries and they won’t know how you did it.
However, since you can’t create a combined chart with all chart types, so you can’t use this Excel Tip/Excel Trick with all of your charts, but it will work many different types.
Let me know if you like the longer legend color rectangles than the standard.
Steve=True
Hello:
I left a comment a while ago but nothing was ever printed. I was trying to duplicate the chart that you developed
and also to make the legends longer. You state that you should make the blank line legend white. I cannot figure
out how to do that.When I select the Legend for the blank line only the txt is selected. I would really appreciate
it if you could help me with this.
John Johnson
Thanks for your comment. I will post a video showing you how to do this after Christmas.
What you need to do is select the line in the chart, not the line in the legend.
Check out this post and video:
How-to Select Data Series in an Excel Chart when they are Un-selectable?
https://www.exceldashboardtemplates.com/how-to-select-data-series-in-an-excel-chart-when-they-are-un-selectable/
Hi John,
I have created a video that will help you see how to do this Excel Tip and Trick.
You can watch the Video here: http://youtu.be/FRVEutwFpWo
Let me know if this helped. Thanks
Steve=True
Great job, Thanks!
Hi Josh,
Thanks for the awesome feedback.
Steve
Thank you.
I am using dashed lines for B&W printing, and the default legend line length does not show a full example of the line.
You have provided a work around that should not have been necessary if Microsoft provided adequate modification of these features.
Glad to help. Thanks for the [email protected]