Aug 14 2006

In cell graphing in Excel

Published by at 4:28 PM under Main

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

No responses yet

Trackback URI | Comments RSS

Leave a Reply