Results 1 to 6 of 6
  1. #1
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts
    I cannot for the life of me figger how to label the legend for the pie chart on the attached spreadsheet.

    I have tried everything I can think of and the closest I came was to add the labels as a tile to the graph.

    I set up hypothetical, and got the pie chart. Fine.

    But I want percentages around the pie, and titles corresponding to the colors over on the legend.

    The data labels should come from A5:A17 on the Budget Detail sheet.

    How the heck do I get them there?

    Regards,
    Chuck Billow
    Attached Files Attached Files
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    The Data you had selected for the chart ONLY had the data from P5:P19 being plotted.

    It should have been A5:A17 and P5:P17

    See attached

    [attachment=88934:Budget Detail and Pie Chart #3.xlsx]
    Attached Files Attached Files
    Andrew

  3. #3
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts
    Quote Originally Posted by AKW View Post
    The Data you had selected for the chart ONLY had the data from P5:P19 being plotted.

    It should have been A5:A17 and P5:P17

    See attached

    [attachment=88934:Budget Detail and Pie Chart #3.xlsx]
    Ah...I'll give that a shot. Thanks Andrew.

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  4. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    See attached
    Attached Files Attached Files

  5. #5
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts
    Tim;

    And you got those there how -- without individual inputs?

    Regards,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  6. #6
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts
    Quote Originally Posted by Tim Sullivan View Post
    See attached

    Tim:

    found it!

    Thanks,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

Posting Permissions

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