How to find the center point of a donut or pie chart

  • Thread starter Thread starter Belinda
  • Start date Start date
B

Belinda

Can anybody shed light how I can figure out programatically if
possible from VBA the center point (X,Y) of a donut chart or a pie
chart.

Thanks
Belinda
 
Belinda -

I'm not sure what you mean. I use a combination Donut-Scatter chart to
make a speedometer chart:

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

I set the axes of the Scatter chart piece of it so the center of the
donut is at 0,0 of the Scatter chart axes.

Somehow I doubt this is what you meant. Feel free to repost with more
details. What is it you're trying to do?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Jon Peltier said:
Belinda -

I'm not sure what you mean. I use a combination Donut-Scatter chart to
make a speedometer chart:

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

I set the axes of the Scatter chart piece of it so the center of the
donut is at 0,0 of the Scatter chart axes.

Somehow I doubt this is what you meant. Feel free to repost with more
details. What is it you're trying to do?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Click to expand...

Jon

Many thanks for taking time to provide your inputs.

I am trying to plot one needle for Actuals, one needle for the plan
and one needle for the variance. WIth your technique of overlying a
scatter chart on a donut is a great idea but when I try to use two or
three needles on the chart having two additional series somehow does
not work. Appreciate if you can let me know how I can have a 2nd and
third needle to show plan and variance.

Also, with one needle I am attempting if I can just show a actual,
plan and variance as atleast a legend with something like the
following:



Actual : xxxxx
Plan : xxxxx
Variance : xxxxx


I could not display the same on the above speedometer graph.

I would appreciate your kind inputs to solve these scenarios.

Thanks
Belinda
 
Hi Belinda -

Keep hanging in there. It sounds like your first needle came out okay,
which is a great first sign.

You have to add each additional needle series separately just like the
first, and change it to a Scatter type series just like the first. If
you formulas are okay, these should give you three needles.

You can embellish your legend to get series name and value together. Use
a formula and the & operator to concatenate the series name and value;
for instance if the name is in F1 and the value is in F2, put this
formula into F3:

=F1&" "&F2

This inserts a space between the name and the value. You can put any
punctuation between or around the labels, and you can control the
display of the value by using number formats. For example, to put a
colon after the name and set the value to have two decimal places, use this:

=F1&": "&TEXT(F2,"0.00")

Now simply use this cell as the name of the series. The easiest way is
to right click on the chart, choose Source Data from the pop up menu,
click on the Series tab, select the series, click in the Name field, and
select the cell (F3) with the mouse.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top