Consulting

Results 1 to 2 of 2

Thread: Solved: Pie chart Percentages

  1. #1
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location

    Solved: Pie chart Percentages

    I have the pie chart attached. What I want to do is show a percentage of the whole as I have done. The problem is that some of the percentages are miniscule and are next to one another and the percentage numbers overlap and are hard to read. Is there a way to correct this? Thanks

  2. #2
    MS Excel MVP VBAX Mentor Andy Pope's Avatar
    Joined
    May 2004
    Location
    Essex, England
    Posts
    344
    Location
    Not using a pie chart.

    Consider using a bar chart instead. You will need to calculate the % with formula

    C1: =B1/SUM($B$1:$B$28)
    Cheers
    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •