Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 +-------------------------------------------------------------------+ |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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
In-cell bar graphs?
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
In-cell bar graphs?
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 -- jswayze ------------------------------------------------------------------------ jswayze's Profile: http://www.excelforum.com/member.php...o&userid=35420 View this thread: http://www.excelforum.com/showthread...hreadid=551891 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
In-cell bar graphs?
These are great links - thanks! If I end up with some sort of hybrid solution I'll post it here. -Jeff -- jswayze ------------------------------------------------------------------------ jswayze's Profile: http://www.excelforum.com/member.php...o&userid=35420 View this thread: http://www.excelforum.com/showthread...hreadid=551891 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions |