• Gerry White

    So – the only problem is that the better at presenting sexy graphs you get – the more your boss wants you to do …! – suddenly it turns into your job! :-)

    This is a great post and I love split axis graphs (one tip – sometimes invert one axis) I love to show a line and bar graph showing change, as it can really highlight negative numbers (I also frequently manually colour in the negative months / weeks) as in 2007 you can’t easily do that automatically!

  • Sharon M. Mullins

    just as Heather replied I didnt even know that someone able to earn $8125 in 1 month on the internet. did you see this web link w­w­w.K­E­P­2.c­o­m

  • http://www.annielytics.com/ Annie Cushing

    LOL,Gerry! You’re absolutely right. When I worked in agencies I was also asked to make coworkers’ data sexy. :) Curious about your tip to invert one axis. I know I do that when charting ranking data since lower numbers are better. Is that what you mean?

    Tip: You don’t have to manually format negative columns in Excel in 2007. Here’s a hack: http://www.hichert.com/de/community/foren?func=view&catid=6&id=150.

  • Gerry White

    Awesome -thanks for the tip (sorry for the slow reply, I thought I had to be honest!)

    I have turned into our internal go to Excel guy – my resolution is to never profess any profficiency in Excel ever again!

    Yes,often the axis direction doesn’t matter, in that the correlation signals are more important… ! As long as it is clear enough (my one bad habit is creating graphs for me, and then including them in presentations without a decent enough explanation)