View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
CMH - AL CMH - AL is offline
external usenet poster
 
Posts: 1
Default Edit Pie Chart Data Label

I am using a pie chart to detail a subset of data and I am having trouble
getting the chart to display the data I need. For example:

Fruit equals 25% of overall diet.

Within fruit I ate:

Fruit # Eaten % of Overall Diet
Apples 10 10%
Oranges 8 8%
Pears 7 7%

I want to graph fruit consumption in pie chart and add all information to
the data label using a link.

I get this to work (click on data label and add location of cells), but I
can't get it to display properly. I am getting

Apples
10 10%

but I want:

Apples
10
10%

Any suggestions?