speedometer & excel 2003 / xp

[arthurlee389951]

I am using the speedometer combination chart as shown by Jon Peltier.
Excellent tips!

Is there any issue with this type of combination chart with Excel 200
/ XP and saving in html?

Thanks,

Arthu

 

[Jon Peltier]

Arthur -

Funny you should ask. Excel XP and 2003 fixed the bug that allowed data
labels to appear outside of the plot area. Actually, I'd been treating
it as a feature that allowed data labels to appear outside of the plot
area. Silly me.

Anyway, I've worked out a way to do the charts in these late versions of
Excel. All I have to do is write it up and put it on my site.

- Jon

 

[Jon Peltier]

Arthur -

Let me know if it works okay:

http://www.geocities.com/jonpeltier/Excel/Charts/SpeedometerXP.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Arthur -

Funny you should ask. Excel XP and 2003 fixed the bug that allowed data
labels to appear outside of the plot area. Actually, I'd been treating
it as a feature that allowed data labels to appear outside of the plot
area. Silly me.

Anyway, I've worked out a way to do the charts in these late versions of
Excel. All I have to do is write it up and put it on my site.

- Jon

 

[hglamy]

Jon,

I had a look at the speedometer chart
and tried to make it work for me.

But I have difficulties in calculating the
"R"-value that you use to represent the
end of the indicator needle.

Would you tell me how you get to "R" ?

Thank you in advance.

Kind regards,

H.G. Lamy

Arthur -

Let me know if it works okay:

http://www.geocities.com/jonpeltier/Excel/Charts/SpeedometerXP.html

- Jon

 

[Jon Peltier]

The way I've set up the chart in the new page, the outside of the blank
series is at 1. The donut hole diameter set to 50%, and there are two
donut series that split the region outside the hole. So the ID and OD
of the 'Donut' data series are at 0.5 and 0.75, respectively, and of the
'Blank' series are at 0.75 and 1.0. I want the tick marks on the inside
of the OD of the 'Donut' series, so 0.75 is one endpoint, and something
less (0.69) is the other endpoint. I want the tick labels outside of
the 'Donut' series, and 0.85 seemed to look good. If you put 0.85,
0.75, and 0.69 in cells someplace and refer all the formulas back to
them, you can modify just these cells to adjust the features until you
get what you need.

- Jon

 

[hglamy]

Thank you Jon,

for your quick and comprehensive response.

However, I'm still not getting where I wanted to go.

I would like to achieve this:
with varying these values in a cell or input table,
the needles shall point to the corresponding values
along the donut border.

When I try to make such a calculation work,
the needles' length varies in relation to donut border.
With value e.g. of 2, or 20, they length of the needles
exceed the outer limit of the donut.

My hope was now, that if I knew what "R" is, or
how it is calculated (in you example it is alway 0.75),
I could keep the needles' endpoint constant in
relation the donut's border when the values change.

Could I make my point (non-native speaker, sorry) ?

Kind regards,

H.G. Lamy

 

[Jon Peltier]

R has to be the length required to meet the outer edge of the donut. In
the '97 and 2000 version, R=1, because the donut reached to the edge of
the plot area, and the axis limits on the XY chart are -1 to 1. In the
XP and 2003 version, the XY axis limits are still -1 to 1, but another
donut series was added. The two donuts split the radial distance from
0.5 to 1, so the outer edge of the visible donut is at R=0.75.

- Jon