View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Lon
 
Posts: n/a
Default Pie Chart to Percentage

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