Results 1 to 3 of 3

Legend for pie chart from pivot table - repeating subcategory

Threaded View

  1. #1
    Registered User
    Join Date
    02-28-2021
    Location
    Oslo, Norway
    MS-Off Ver
    365 16.46
    Posts
    2

    Legend for pie chart from pivot table - repeating subcategory

    I was hoping somebody could help.

    I attach a file of my data, pivot table and resultant pie chart. I want a way for the legend to just have the categories, 'blue', 'red' and 'yellow', and not to have 'big' in front of each. Is it possible?

    The big is the sub-category that I am sorting for in the pivot table.

    Thanks for your help!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by neuvilla; 02-28-2021 at 11:56 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 12-04-2020, 05:01 AM
  2. [SOLVED] Pivot Chart Legend
    By MarkN in forum Excel General
    Replies: 3
    Last Post: 09-20-2016, 07:51 PM
  3. Dynamic Legend Pivot Chart
    By rpinxt in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-08-2016, 04:43 AM
  4. [SOLVED] Pivot chart not displaying all of my legend
    By BEJAI 66 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2016, 03:30 PM
  5. Pivot Chart Legend Format
    By Huddle in forum Excel General
    Replies: 5
    Last Post: 04-04-2011, 11:58 AM
  6. Obtaining a pivot chart Legend name
    By zasskar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2006, 11:07 AM
  7. Change a legend in Pivot Chart Report
    By SJT in forum Excel General
    Replies: 2
    Last Post: 02-28-2006, 04:50 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