Brick Charts in Excel – an Alternative to Gridlines


Share on facebook
Share on twitter
Share on linkedin

Grid lines provide great help in understanding values in a chart. Here is a handy trick you can use in the next bar chart to spice it up.

Here is how you can get this type of chart (we will call it a brick chart)

  1. First we will make a regular bar chart
  2. Now, let us assume we want each brick to be of 5 units width. So we take another column in the worksheet and enter the value 1 twenty times. This will be a dummy series that we will add to the chart. Just copy these 20 cells and paste them in to the chart. (just press ctrl+c after selecting the dummy value cells, and then select the chart you made in step 1 and press ctrl+v)
  3. Now we will change the dummy series’ chart type from bar chart to column chart. Just select the newly inserted series in the chart and right click and select chart type. In the chart type dialog, change the type.
  4. Now the new chart will look like this. We will adjust the secondary axis parameters so that the columns will span the entire height of the chart. Just use the format axis dialog for this.
  5. Once the columns are of sufficient height, we will adjust their fill color to transparent (none) and line color to white. This will produce the following effect.
  6. Finally, remove the unnecessary chart junk like axes and you have a neat looking brick chart.

Download the excel brick chart template and play with it.

PS: making this type of charts is slightly difficult compared to normal charts. What we have done here is, we mixed two types of charts. These are called combination charts. We will explore more about this type of charts later.

Share on facebook
Share on twitter
Share on linkedin

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Chandoo is an awesome teacher

– Jason

Excel formula list - 100+ examples and howto guide for you

100 Excel Formulas List

From simple to complex, there is a formula for every occasion. Check out the list now.

20 Excel Templates

Calendars, invoices, trackers and much more. All free, fun and fantastic.

IRR and data tables in Excel

Using IRR with Data Tables – Modeling Cash-flow Scenarios in Excel

Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this article is for you. In this page, learn how to,

  • Introduction to IRR & XIRR functions
  • Calculate rate of return from a set of cash-flows with XIRR
  • Simulating purchase or terminal value changes with data tables
  • Apply conditional formatting to visualize the outputs
  • Common issues and challenges faced when using XIRR

6 Responses to “Brick Charts in Excel – an Alternative to Gridlines”

  1. Peder Schmedling says:

    Now that's a neat trick!

    Thank you so much, I will definitively use this 😀

    best regards

  2. Tony Rose says:

    I'm not sure adding the vertical grid lines adds value to the chart... I think you can get the same, if not better, effect by having solid bars or columns.

    Maybe if the lines were minimized instead of being so obvious, it might be better.

    This might fall into my category of chartjunk.

  3. nixnut says:

    I agree with Tony. juiceanalytics.com has an example with more modest grid lines:

  4. WebGenii says:

    I like the repeating shape that makes it easy to see values.
    I prefer to paste a shape into data range, scaling the shape to a value.

  5. Chandoo says:

    @Peder: You are welcome 🙂

    @Tony: They need not be vertical alone. For column charts you can have them horizontally. Anyways, These are merely an alternative to gridlines and can be used to get the brick effect. Personally I prefer thin grayish white gridlines for my charts and try to avoid them if I can.

    @nixnut: thanks for the link. There are several alternatives to gridlines.

    @WebGenii: welcome to PHD. Repeating shapes is another neat technique.

  6. Kiran says:

    Please chandoo also show.example.of horizontal grid.lines for brick chart

Leave a Reply