View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default In-cell bar graphs?

Here are a couple of ways,

http://j-walk.com/ss/excel/usertips/tip052.htm

This is the last in a series of posts.
http://blog.livedoor.jp/andrewe/arch....html#comments

This is a line but the principle can be adapted.
http://www.dailydoseofexcel.com/arch...cell-charting/

Cheers
Andy

jswayze wrote:
I'd like to present some data within the cells of a spreadsheet instead
of a separate graph. Basically I want to partially fill the cell from
left to right to indicate a value. I've enclosed an example (modified
in Photoshop) to show what I mean.

Does anyone know of any tricks to do this? Visual Basic? A scaled
graphic? A plug-in?

Thanks in advance for any advice.

Regards,

Jeff


+-------------------------------------------------------------------+
|Filename: graph_example.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4887 |
+-------------------------------------------------------------------+


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info