Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Drawing a semi-circle in Excel

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   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Drawing a semi-circle in Excel

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Drawing a semi-circle in Excel

Thanks Max :)
  #4   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Drawing a semi-circle in Excel

You're welcome !
--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
----

"Shilps" wrote

Thanks Max :)



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Drawing a semi-circle in Excel

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default Drawing a semi-circle in Excel

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 459
Default Drawing a semi-circle in Excel

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Drawing a semi-circle in Excel

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Semi-circle chart in Excel 2003 Oil Man Neil Charts and Charting in Excel 2 September 12th 07 01:38 PM
Intersection between a line and multiple semi circle curve Geminist Charts and Charting in Excel 5 February 12th 07 08:45 PM
how do i make a "dashboard style" chart (semi circle & pointer) SamanthaGaszczak Charts and Charting in Excel 1 November 16th 05 09:30 PM
drawing/printing an exact circle talisman New Users to Excel 4 October 23rd 05 11:39 PM
Drawing a circle on a protected sheet Tonso Excel Discussion (Misc queries) 3 April 9th 05 09:22 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"