+ Reply to Thread
Results 1 to 2 of 2

Pivot Chart not displaying data label values for the first Legend label

  1. #1
    Registered User
    Join Date
    07-27-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    12

    Pivot Chart not displaying data label values for the first Legend label

    I am currently displaying a pivot chart with data of Hours per week of an employee. It has the Week on the horizontal Axis and Hours on the vertical axis Axis with users as legend.
    I also have a slicer that would let me to select different users.

    When I change the users, the data label of the first user doesn't seem to appear on the chart, I've tried to change the pivot chart settings but none of the change helped me with this.
    I have attached an image of how the chart looks like

    Can someone please point me towards the right direction to proceed

    Edit- I would not be able to attach the excel here as the slicer list / chart data comes from the database query result according to the slicer option selected and I use Microsoft query for that.

    Thanks.
    Attached Images Attached Images
    Last edited by zykkzxxy789077; 08-23-2016 at 11:12 AM.

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13
    Posts
    953

    Re: Pivot Chart not displaying data label values for the first Legend label

    Hi,

    I need your file to investigate further.

    Can you create a file with dummy data that demonstrates the behaviour & post it to the forum?
    Remember you are unique, like everyone else

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to show Negative Data Label Values in Red - Waterfall Chart
    By kirtanpatel85 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-31-2014, 03:35 PM
  2. Replies: 1
    Last Post: 09-30-2013, 09:52 AM
  3. Replies: 0
    Last Post: 06-18-2013, 10:42 AM
  4. Pivot Table to roll up data and display in pivot chart
    By Dawson64 in forum Excel General
    Replies: 3
    Last Post: 09-26-2011, 05:06 PM
  5. Replies: 5
    Last Post: 01-27-2009, 11:22 AM
  6. Pivot Pie Chart Data Label renaming
    By matpj in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-22-2007, 12:07 PM
  7. [SOLVED] Pivot Chart Data Label Format Question
    By Dominic in forum Excel General
    Replies: 3
    Last Post: 03-01-2006, 04:00 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1