Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Keep losing percentages on Pivot Chart

    In the attached Excel workbook, Ive created a Pivot Chart.

    I keep on losing the percentages that sit on top of the bar charts, every time I change the filter on the service pivot

    Is it possible to maintain them for each individual service, so their percentages are as clear as possible?
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. If I understand correctly, you can right-click the chart and choose Chart Options. Choose Data Labels, and click on Value. However, if you don't show all Services, it will always show 100% for the individual Service selection.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Cross posted at Access-programmers at the same time.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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