Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I want to draw a health-meter kinda thing on the lines of speedometer. it will be a semi-circle inside which a line joining the centre to the circumference will move on the basis of three indices The best condition is shown when the angle is 180 degree and the worst is when it is 0 degree There are two limits -one is warnign limit and the other is danger limit As the line crosses the warning limit, the area beyond that will be yellow in colour and after the danger limit, it will show in red How can I do tha TI Shilps |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Maybe try Jon Peltier's:
http://www.peltiertech.com/Excel/Cha...ts.html#Speedo and Andy Pope's: http://www.andypope.info/charts/gauge.htm -- Rgds Max xl 97 --- Please respond, in newsgroup xdemechanik <atyahoo<dotcom ---- "Shilps" wrote in message ... Hi, I want to draw a health-meter kinda thing on the lines of speedometer. it will be a semi-circle inside which a line joining the centre to the circumference will move on the basis of three indices. The best condition is shown when the angle is 180 degree and the worst is when it is 0 degree. There are two limits -one is warnign limit and the other is danger limit. As the line crosses the warning limit, the area beyond that will be yellow in colour and after the danger limit, it will show in red. How can I do that TIA Shilps |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Max :)
|
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You're welcome !
-- Rgds Max xl 97 --- Please respond, in newsgroup xdemechanik <atyahoo<dotcom ---- "Shilps" wrote Thanks Max :) |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hello,
I want to create a dashboard also..with these kind of meters everything should by dynamic...and figures will be changed daily. Is there somebody that can help me.. Thx in advance. Marco -- Message posted from http://www.ExcelForum.com |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Marco -
Here's a technique to construct dashboard-type charts. If you link the needle values to your daily values, you should be able to make them dynamic. http://peltiertech.com/Excel/Charts/SpeedometerXP.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ mvdh < wrote: hello, I want to create a dashboard also..with these kind of meters. everything should by dynamic...and figures will be changed daily. Is there somebody that can help me.. Thx in advance. Marco. --- Message posted from http://www.ExcelForum.com/ |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Shilps wrote in message ...
Hi, I want to draw a health-meter kinda thing on the lines of speedometer. it will be a semi-circle inside which a line joining the centre to the circumference will move on the basis of three indices. The best condition is shown when the angle is 180 degree and the worst is when it is 0 degree. There are two limits -one is warnign limit and the other is danger limit. As the line crosses the warning limit, the area beyond that will be yellow in colour and after the danger limit, it will show in red. How can I do that TIA Shilps What bit is troubling you? Is it that your 'speedometer' looks like it is on it's side? Try starting with the best condition at 270 degrees and the worst at 90 degrees. Is it the semi-circle shape? If so, try a horizontal display to start with (I've seen actual speedometers that look like this though the 180 was probably kph rather than mph), it could be easier to conceptualize. Is it the colors? On Excel's Drawing toolbar you want the button that looks like a pot of paint being tipped over. Is it that you want someone to create and code everything for you? Hmmm, I dunno about that one. -- |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Well for one thins, I cannot use the tool bar...since this meter will move on the basis of the metrics, it has to be automated. And that means it has to be through VBA. And I donno how to create a drawing object through VB Scripting.
:) Hope this clarifies how novice I am in this area and what kinda help I am looking for. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Semi-circle chart in Excel 2003 | Charts and Charting in Excel | |||
Intersection between a line and multiple semi circle curve | Charts and Charting in Excel | |||
how do i make a "dashboard style" chart (semi circle & pointer) | Charts and Charting in Excel | |||
drawing/printing an exact circle | New Users to Excel | |||
Drawing a circle on a protected sheet | Excel Discussion (Misc queries) |