I've created a pie chart whose "slices" are automatically re-sized when I
type a percentage into a cell. Now I'd like to be able to reverse the
process. That is, I'd like to be able to re-size the pie-slice, using my
mouse cursor, and have that change the number in the percentage cell. Can
that be done?

Hi,

Surprisingly yes!

Create a pie chart with 4 cells each with the value 1.
Then select the pie chart and then select the top right slice.
Move your mouse to the bottom right edge of the slide, 3 o'clock
position. The cursor should change from a pointer to a cross-hair. You
should now be able to click and drag the slice and change its value
rather than explode it.

Cheers
Andy

Lon wrote:
I've created a pie chart whose "slices" are automatically re-sized when I
type a percentage into a cell. Now I'd like to be able to reverse the
process. That is, I'd like to be able to re-size the pie-slice, using my
mouse cursor, and have that change the number in the percentage cell. Can
that be done?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Excellent! Thanks Andy.

-Lon

"Andy Pope" wrote in message
...
Hi,

Surprisingly yes!

Create a pie chart with 4 cells each with the value 1.
Then select the pie chart and then select the top right slice.
Move your mouse to the bottom right edge of the slide, 3 o'clock position.
The cursor should change from a pointer to a cross-hair. You should now be
able to click and drag the slice and change its value rather than explode
it.

Cheers
Andy

Lon wrote:
I've created a pie chart whose "slices" are automatically re-sized when I
type a percentage into a cell. Now I'd like to be able to reverse the
process. That is, I'd like to be able to re-size the pie-slice, using my
mouse cursor, and have that change the number in the percentage cell. Can
that be done?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info