ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Edit Pie Chart Data Label (https://www.excelbanter.com/charts-charting-excel/200664-edit-pie-chart-data-label.html)

CMH - AL

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?


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com