By now everyone and their grandmother must have known about how Republican National Committee has spent $ 150,000 on Sarah Palin’s clothing and make up. I am a big fan of clothes. So much that I wear them everyday. But not all of us have a committee or fund raisers to dress up ourselves, none the less for our charts and reports.
That is where you can find Pointy Haired Dilbert useful. I am going to share with you all 5 simple yet effective ways to dress up your charts without spending a penny (or not more than few minutes of time).
1. Use Gradients, Pattern Fills instead of Colors
Select the data series you want to fill with gradient fill (or patterns) and right click, select “format data series”. In the dialog click on “Fill effects” and navigate to gradient tab (or patterns).
Note: go easy on gradients as they may not always gel well with other objects on your slide / report.
2. Use Images to Fill instead of Colors
If using gradients is playing with colors, you can use images to fill the bar (or pie or area) of the chart to decorate your charts. One of the good uses of this technique is to fill each series element with the image of what it represents. For eg. if you are showing sales of your products, fill each bar with small images of your product.
Just right click on the data series element, select format, and in the fill effects dialog, navigate to either “picture” tab. Don’t forget to click on “stacked” option. Otherwise excel would try to stretch your image to fit in the fill area and it looks ugly.
3. Add Text to Chart Area to Grab User Attention
This is one of my favorite technique. You can grab user attention using call outs placed on the chart.
Just select the chart and start typing anything. You will see a new text area added to your chart (the text area is bound to chart, so when you copy paste the chart even this text will be pasted). Now format the text area using drawing tool bar to a call out or star or something nice.
4. Use Bold and Creative Colors
Just go to Colorlovers or Smashing Magazine. Get some design inspiration on which colors to use. Now once you have the colors, just create 1×1 pixel images for each color in your favorite image editor. Then specify these images as fill images (learn more about overcoming 56 color limitation in excel). You now have excel charts that are bold and colorful.
5. Replace the Labels with Company Logos
Instead of using those boring labels to describe what each element on your chart means, you can use images to the story. See how you can yummify a simple “break-up of breakfast snacks in the last 30 days” chart.
Select the chart. Now go to Menu > Insert > Picture > From File and select your company logos or product images or something that conveys what the label does. Adjust the images and re-size them. 🙂
Of course, you can always download these 73 beautiful excel chart templates for free and become a formatting rock star overnight.
More Excel Charting Ideas and Tips.
Subscribe to our RSS Feeds or Email News Letter and get these and many more Excel tips delivered to your desktop.
All these tips are tested on Excel 2003. Palin’s Image is from Wikipedia.
14 Responses to “Group Smaller Slices in Pie Charts to Improve Readability”
I think the virtue of pie charts is precisely that they are difficult to decode. In many contexts, you have to release information but you don't want the relationship between values to jump at your reader. That's when pie charts are most useful.
[...] link Leave a Reply [...]
Chandoo,
millions of ants cannot be mistaken.....There should be a reason why everybody continues using Pie charts, despite what gurus like you or Jon and others say.
one reason could be because we are just used to, so that's what we need to change, the "comfort zone"...
i absolutely agree, since I've been "converted", I just find out that bar charts are clearer, and nicer to the view...
Regards,
Martin
[...] says we can Group Smaller Slices in Pie Charts to Improve Readability. Such a pie has too many labels to fit into a tight space, so you need ro move the labels around [...]
Chandoo -
You ask "Can I use an alternative to pie chart?"
I answer in You Say “Pie”, I Say “Bar”.
This visualization was created because it was easy to print before computers. In this day and age, it should not exist.
I think the 100% Bar Chart is just as useless/unreadable as Pies - we should rename them something like Mama's Strudel Charts - how big a slice would you like, Dear?
My money's with Jon on this topic.
The primary function of any pie chart with more than 2 or 3 data points is to obfuscate. But maybe that is the main purpose, as @Jerome suggests...
@Jerome.. Good point. Also sometimes, there is just no relationship at all.
@Martin... Organized religion is finding it tough to get converts even after 2000+ years of struggle. Jon, Stephen, countless others (and me) are a small army, it would take atleast 5000 more years before pie charts vanish... patience and good to have you here 🙂
@Jon .. very well done sir, very well done.
good points every one...
I've got to throw my vote into Jon's camp (which is also Stephen Few's camp) -- bars just tend to work better. One observation about when we say "what people are used to." There are two distinct groups here (depending on the situation, a person can fall in either one): the person who *creates* the chart and the person who *consumes* the chart. Granted, the consumers are "used to" pie charts. But, it's not like a bar chart is something they would struggle to understand or that would require explanation (like sparklines and bullet graphs). Chart consumers are "used to" consuming whatever is put in front of them. Chart creators, on the other hand, may be "used to" creating pie charts, but that isn't an excuse for them to continue to do so -- many people are used to driving without a seatbelt, leaving lights on in their house needlessly, and forwarding not-all-that-funny anecdotes via email. That doesn't mean the practice shouldn't be discouraged!
[...] example that Chandoo used recently is counting uses of words. Clearly, there are other meanings of “bar” (take bar mitzvah or bar none, for [...]
[…] Grouping smaller slices in pie chart […]
Good article. Is it possible to do that with line charts?
Hi,
Is this available in excel 2013?