In cell graphing in Excel

I am using Excel 2007 full time now and I really like the in cell graphics and easy to use conditional formatting,  I have never been a power user of Excel and it’s taken the discoverability of the ribbon based interface to help me improve in this area.  I have also got interested enough in Excel to subscribe to the JuiceAnalytics blog which has some great tips on Excel.  The most impressive is a series of tips on how to do in cell graphics in older versions of Excel and I was surprised to find that in many ways they are superior to those in Excel 2007 and not too much more difficult to use after a bit of practice.  Check out these examples!

Using two columns to show positive/negative values

 

In cell bar graphs using rept--looking good

 

A labeled bar graph

Steve Richards

I'm retired from work as a business and IT strategist. now I'm travelling, hiking, cycling, swimming, reading, gardening, learning, writing this blog and generally enjoying good times with friends and family

Leave a Reply

Your email address will not be published. Required fields are marked *