Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pie Chart (2003)

    Hi,

    I create a pie chart in excel. For some reasons, I can't make Legend shows really titles. If I include data title with data in data source, the pie chart only shows a line. So I only include data in datasource, then Pie chart shows fine. But the legend shows all numbers. Please see attached.

    So how can I shows data title in the legend?

    Thanks

    Regards
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Pie Chart (2003)

    <P ID="edit" class=small>(Edited by sdckapr on 06-Nov-07 18:21. Added PS)</P>In the "SourceData", Make the "Category Label":
    =Sheet1!$E$28:$G$34

    To display the A-G in the Legend.

    Steve

    PS: When creating a chart using the WIZARD, with categories, leave the "category header" blank (you can have one on the value which will be the default title. You can add the title to the data after the chart is created.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pie Chart (2003)

    Thanks, Steve.

Posting Permissions

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