fbpx
Search
Close this search box.

Use Shapes and Images to make Prettier Charts [Dashboard Tricks]

Share

Facebook
Twitter
LinkedIn

One of the annoyances of charts is that they all look like boxes (except for pie charts, they just look wrong). Boxes might be ok when you are making 1 or 2 charts. But a whole dashboard of boxes can look little rigid. So how can we make the charts peppy without loosing any effect? Like these charts below:

Use Shapes and Images make Prettier Charts [Dashboard Tricks]

Very simple, we use drawing shapes in MS Excel to draw whatever we want and overlay the chart on top.

See this 3 step tutorial.
Use Shapes with Charts - Tutorial

Step 1: Make the chart

This is simple, just make the chart and remove the background color. Also adjust series colors so that they look good when you combine the chart with drawing shape.

Step 2: Make the drawing

Go to Insert > Shapes (in excel 2003, select drawing toolbar and draw a shape) and insert some shapes. Arrange them so that you get desired effect.

Step 3: Put Chart on top of Drawing

This is simple. Just drag the chart on to the shape (s). If needed “send shapes to background”. That is all.

Download Example Charts

Click on these links to download example charts – Excel 2007 | Excel 2003

There are millions of possibilities when using shapes. Try something new for your next dashboard or report.

Note: Shapes can add clutter if you overdo them. Remember, the purpose is to let readers focus on the chart, not on shapes.

Additional material on excel dashboards.

Facebook
Twitter
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

Excel School made me great at work.
5/5

– Brenda

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

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

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

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

16 Responses to “Use Shapes and Images to make Prettier Charts [Dashboard Tricks]”

  1. Jon Peltier says:

    Most important message:

    Shapes can add clutter if you overdo them. Remember, the purpose is to let readers focus on the chart, not on shapes.

    Otherwise you may as well Send in the Clowns.

  2. Mark says:

    In short, you are talking about using chart backgrounds. That is pretty normal with software vendors demonstrating their products but little impractical as it involves addtional time to embed them.

    Cheers
    Mark
    DashboardZone

  3. Though sometime this approach could be useful for concept-heavy shapes such as the Value Chain or Balance Scorecard.

  4. Alex Kerin says:

    I like it - we can all pretend that everyone just wants the data, and reducing the non-data ink to a minimum is everyone's goal, but most non-data people like a bit of pizazz.

    This is especially true when the dashboard ends up as part of a product that sales people have to take on the road - the challenge is to present great data in a nice format without taking the easy road with gauges and 3D oblique pie charts.

  5. Paramdeep says:

    Hey Chandoo,

    This is a great way to represent charts. I have found this to be very effective, while creating and illustrating concepts like Du-pont analysis, composition of revenues, P&L, Balance sheet etc.

  6. Chandoo says:

    @Mark: I would not say this is same as background. At a high level, they are but, using shapes to add context to charts is a bit more than simple chart back ground. For eg. as Paramdeep & Bernanr below pointed out, using shapes to make a balanced score-card dashboard is pretty common.

    @Alex: Exactly my point. Pure data is good, but some times a bit of variety makes very good impact.

  7. paresh shah says:

    Hi

    I am slowly getting convinced that it may not be a very bad idea using some 'eye candy' in business charts.

    The way I look at it - for my personal analysis - use wire frame charts or minimalist charts.

    For presentation of my finding use some eye candy - hey we need to get the idea across.

  8. jeff weir says:

    Chandoo...you'll find one of the best charts ever at http://www.venganza.org/about/open-letter/

    It's informative, pretty, and fun.

    I suggest you read the words above the chart first, rather than just scrolling down to the chart. The wikipedia article at http://en.wikipedia.org/wiki/Flying_Spaghetti_Monster is also a good backgrounder.

  9. [...] 5, 2009 Chandoo provides an interesting use of layering Excel objects to add background effects to charts. This [...]

  10. This interesting. The underlying technique, layering, is rarely used. However, it has far more applications that placing an image beneath a graph. Laying is a powerful and flexible method for integrating multiple charts, integrating charts with non-chart report elements, formatting and customizing charts, and creating compound charts. I elaborate and provide examples at:
    http://pushindatalikeweight.com/2009/12/05/layering-in-excel/

  11. Elidia Tolle says:

    Hello it was a pleasure visting your blog.

  12. [...] augmenting his dashboard interface with Excel Shapes. The talented Chandoo touches on this a bit in his post on using shapes to make prettier charts. That was a good start and gave me a few ideas of my [...]

  13. […] Excel, due to its grid nature makes everything look like a box. But boxes can be dull and boring. Thankfully we can use Text boxes & Drawing shapes to add variety to our dashboards. What’s more, you can even link these to cells so that they can display values.  See this blog article for an example: Use drawing shapes to enhance dashboards […]

Leave a Reply