[Weekend Poll] How do you Sex up your Charts?


This weekend, let us talk … umm… charts. I want to know if you absolutely make sure your charts look good everytime you sent them out to someone. I do this most of the time.

My usual chart sex up routine is,

  • Remove the background
  • Add labels and remove grid lines and legend
  • Highlight necessary data and set some dull color to the rest (if needed)
  • Change fonts, most often change them to Verdana
  • Format axis and axis labels

Of course, I don’t do this every time. Instead I use some user defined charts and save tons of time.

How do you sex up your charts? or you say “not tonight honey” to them.

Learn 2 more charting principles in naughty but totally fun way: Is your chart’s underwear showing? | Are you making blow charts?

Chandoo

Hello Awesome...

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.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Written by Chandoo
Tags: , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

4 Responses to “[Weekend Poll] How do you Sex up your Charts?”

  1. Andreas says:

    You might consider removing the category axis labels

    Andreas

  2. Tony Rose says:

    I can just imagine the SPAM you're getting with this post.

  3. Chandoo says:

    @Andreas: I doubt if that would lead to information loss as there is no way to know what we have plotted here then.

    @Tony: yeah... but askimet does the dirty job

  4. Nando says:

    Are these the only tips you have, these are extremely basic and frankly i was expecting a lot more. The chart is very unclear, not titles are axis headings! Disappointed!

Leave a Reply


« »