Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a shape as a gauge.
Oh Wise Ones,
How can I use a shape as a gauge? I couldn't get a chart to not look like a chart. I want to indicate the contents of a cell - lets say A1 as a percentage. So if A1 contains 50 the shape is half full etc. It's not quite a progress bar, but would look like one. Horizontal if possible. Thanks, Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a shape as a gauge.
One very simple way
=REPT("|",A1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike K" wrote in message ... Oh Wise Ones, How can I use a shape as a gauge? I couldn't get a chart to not look like a chart. I want to indicate the contents of a cell - lets say A1 as a percentage. So if A1 contains 50 the shape is half full etc. It's not quite a progress bar, but would look like one. Horizontal if possible. Thanks, Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a shape as a gauge.
Thanks Bob! That's really slick. I was kinda out of free cells but I'll find
a way to wedge it in there. Thanks again, Mike "Bob Phillips" wrote: One very simple way =REPT("|",A1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike K" wrote in message ... Oh Wise Ones, How can I use a shape as a gauge? I couldn't get a chart to not look like a chart. I want to indicate the contents of a cell - lets say A1 as a percentage. So if A1 contains 50 the shape is half full etc. It's not quite a progress bar, but would look like one. Horizontal if possible. Thanks, Mike |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a shape as a gauge.
Here's a good example of using a chart to create a guage of sorts:
http://www.andypope.info/charts/gauge.htm There are others out there that look more like progress bars, etc. Just Google something like "+excel +gauges +vba" and you'll find some good examples. HTH, Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
gauge charts and dashboards | Charts and Charting in Excel | |||
Gauge/Dashboard Charts | Excel Programming | |||
Where can I find and how to use gauge graphs? | Charts and Charting in Excel | |||
both a chart and a gauge (an activeX) | Charts and Charting in Excel | |||
Happy Face gauge not updating. | Excel Programming |