Tips and Tricks – Longer Legend Color Bars in Excel Charts

Excel Legend Tips and Tricks

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.

If you found the website and tutorials helpful, please consider donating to keep the lights on.

Donate with PayPal here:


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.



  1. 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

  2. If you found the website and tutorials helpful, please consider donating to keep the lights on.

    Donate with PayPal here:

  3. 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.


Please enter your comment!
Please enter your name here