speed'0'meter needle

[engrzubair]

i hope someone can help me with this.
i've made a "meter" with the help of excel scatter chart but the needle is quite ordinary.
Is it possible to add a customized needle to this chart?
please have a look!

help wud be highly appreciated....

[oldchippy]

If this guy can't improve on it, then it's probably not possible?

http://peltiertech.com/Excel/Charts/Speedometer.html

[engrzubair]

oldchippy! thanx for ur reply......
there must be a way of doing it....anyways....

one more question:

if i rotate a diagram (rectangle) in excel, its pivot lies always around its center.

is it possible to change that pivot to its one end and then rectangle rotate about that end?

[oldchippy]

On the Drawing Toolbar > Draw > Rotate or Flip > Free Rotate, that moves it to any corner

Take a look at this link for jazzing up your speedometer dial

http://www.andypope.info/charts/spectrum.htm

[jpgoeth]

Another link - explains how to make the needle using a filled-in wedge of a pie chart

http://www.windowsdevcenter.com/pub/...p05/index.html