asked on

Excel: Formatting pie chart - Show in legend the values

Experts,

I am redoing charts from crystal reports to excel, still wanting to keep the same chart design. In excel (pie chart) I am trying to add in the legend the name and percentage. Looks like this:

Legend:
HD-ODN 64.0%
HD-DVR ODN 24.1%
HD iGuide 16.2%

I have attached the chart in crystal, but would like to know how can I build the same chart in excel. If not, any ideas to a similar design?
Thanks

2007 excel

chart-example.xlsx

Glenn Ray

In the simplest terms, you would add a new label column that could combine the Group (ex., "HD-ODN") to a rounded value of the actual population. You could hide this column if you wished.

Unfortunately, that does not provide you a separate data table on the bottom showing the percentages. However, I added percentages to the data labels using Excel's built-in features.

See the attached example.

-Glenn
EE-chart-example.xlsx

Maliki Hassani

ASKER

Thanks Glenn, I appreciate your help. I will keep this open a few more hours just to see if any other ideas are available.

Glenn Ray

I forgot to round down the values to "K" so I've updated the workbook here.

Still, you can't add a data table to a pie chart (you can for a bar chart). Short of creating a second table, I'm not sure how one could do it.

Regards,
-Glenn
EE-chart-example.xlsx

Maliki Hassani

ASKER

Bar chart, maybe that is the fix?

ASKER CERTIFIED SOLUTION

Glenn Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Maliki Hassani

ASKER

Thank you!!

Glenn Ray

You're welcome. Surprised, but glad that this solution will work for you.

Side note: note that I inserted a line feed (CHAR(10)) in the formulas for the modified labels; this forces the percentage to a separate line below the group name.

-Glenn

Maliki Hassani

ASKER

cool thanks! I will need this in my reports