Make info-graphics with shape fill technique [Charting Tip]
This is a quick, fun and elegant way to make impressive charts. You can easily create info-graphic style charts in Excel using shape fill technique. Something like this:
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 above.
Looks interesting? Read on…
Happy Birthday Hui, An Excel Dashboard to prove you are awesome!
Some of you know our guest author and Excel ninja Hui. Yesterday was his birthday. And I wanted to create nice birthday gift for him. So I took a database dump of our forums data and created a dashboard.
Read rest of this post to see the dashboard & download workbook.
Use Shapes and Images to make Prettier Charts [Dashboard Tricks]
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:
Very simple, we use drawing shapes in MS Excel to draw whatever we want and overlay the chart on top.