In-cell bar graphs?

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

Download Excel 2007 beta - it can do just what you want!
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"jswayze" <[email protected]> wrote in
message news:[email protected]...
>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> jswayze
> ------------------------------------------------------------------------
> jswayze's Profile:
> http://www.excelforum.com/member.php...o&userid=35420
> View this thread: http://www.excelforum.com/showthread...hreadid=551891
>

I look forward to trying it, however I'm stuck with Excel 2000 at work, so I'd like to find a solution in the interim.

I did play with creating a Picture Object in a cell, then having it resize with the cell. I don't have time to figure out the VB at this point though, so I'm hoping to "borrow" someone else's implementation of this if possible.

Thanks,

Jeff

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

These are great links - thanks!

If I end up with some sort of hybrid solution I'll post it here.

-Jeff