+ Reply to Thread
Results 1 to 4 of 4

Legend issue with Pivot Charts

  1. #1
    Registered User
    Join Date
    04-04-2022
    Location
    Melbourne, Australia
    MS-Off Ver
    365
    Posts
    2

    Legend issue with Pivot Charts

    Hi

    I have created an Excel interactive dashboards using pivot charts and slicer for the period Fen and Mar 2022
    On the attached, the first image shows both Feb and Mar data with the months in the legend. When I select Feb in the slicer only Feb data is shown along with only Feb in the legend.
    However when I select Mar in the slicer, while the graph displays Mar data, where Mar 22 should show in the legend, its been replaced by the items listed in the X axis. I have tried deleting and recreating the graph however the issue remains
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,440

    Re: Legend issue with Pivot Charts

    You can get that to happen if you format a single data point within a series.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-04-2022
    Location
    Melbourne, Australia
    MS-Off Ver
    365
    Posts
    2

    Re: Legend issue with Pivot Charts

    Can you please explain the process, I have googled it and the results don't relate to my issue

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,440

    Re: Legend issue with Pivot Charts

    select a single data point in one of the series in your column chart.
    Then filter so only that series is showing. The legend will change from Series Name to Category Names.

    If not you problem you will need to post an example file that illustrates your problem, rather than pictures.

+ 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. Replies: 2
    Last Post: 10-08-2014, 05:30 AM
  2. Legend in Pie Charts
    By aussiegirl in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-17-2012, 07:07 AM
  3. Separate legend for multiple pie charts?
    By kirrwed in forum Excel General
    Replies: 1
    Last Post: 12-09-2011, 12:52 PM
  4. Charts: Legend problem with variable length
    By LouSifer in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 11-11-2008, 07:28 AM
  5. Legend Formatting In Charts
    By skizz135 in forum Excel General
    Replies: 1
    Last Post: 08-07-2008, 02:45 PM
  6. [SOLVED] Increase size of Legend Key in Pie Charts
    By Mark in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-08-2006, 02:25 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