Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6698
  • Last Modified:

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
0
Maliki Hassani
Asked:
Maliki Hassani
  • 4
  • 4
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
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
0
 
Maliki HassaniAuthor Commented:
Thanks Glenn, I appreciate your help.  I will keep this open a few more hours just to see if any other ideas are available.
0
 
Glenn RayExcel VBA DeveloperCommented:
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
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Maliki HassaniAuthor Commented:
Bar chart, maybe that is the fix?
0
 
Glenn RayExcel VBA DeveloperCommented:
Bar chart: here's a first attempt (see second sheet).
EE-chart-example.xlsx
0
 
Maliki HassaniAuthor Commented:
Thank you!!
0
 
Glenn RayExcel VBA DeveloperCommented:
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
0
 
Maliki HassaniAuthor Commented:
cool thanks!  I will need this in my reports
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now