Use shapes to enhance your Excel charts [tip]
Here is a simple way to enhance your Excel charts – use shapes & pictures in your charts.
We will learn how to create something like this:
Looks interesting? Read on…
How to add drawing shapes / pictures to your charts
Watch this quick video tutorial to understand the process for adding shapes / pictures to your charts. We start by creating a simple chart filled with custom shape. Once the basic technique is clear, we then build an interactive chart that moves an arrow symbol based on user input. Pretty sweet.
Download shapes in your charts – Example workbook
Please download the example workbook and use it to understand this chart better.
More ways to use shapes in your charts
Check out few more fun & informative ways you can use shapes in your charts
- Understanding the effect of Grammy award on album sales – Grammy Bump Chart in Excel
- Create a column chart with background image
- Use shapes to make pretty charts
- Shapes in a dashboard – Celebrating India’s cricket worldcup victory
Share your shapes in chart idea & you could win Amazon gift card
This post is part of Awesome August Excel festival @ Chandoo.org.
To celebrate Awesome August, I am giving away $31 worth Amazon gift card to one lucky winner per post. You can participate in this contest by,
- Create a chart with shapes / pictures following the principles explained in the video
- Take a screenshot of your chart
- Upload the image to a free image hosting site like imgur or tinypic
- Post the link along with why you made the chart in comments section of this post
- One lucky participant gets $31 Amazon Gift card at the end of August.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Remove duplicate combinations in your data [quick tip]||Declutter your reports by showing icon only »|