+ Reply to Thread
Results 1 to 3 of 3

Getting chart data labels to be different to the label on the pivot table

  1. #1
    Forum Contributor
    Join Date
    07-07-2019
    Location
    london
    MS-Off Ver
    2013
    Posts
    105

    Getting chart data labels to be different to the label on the pivot table

    Hi,

    i would like to my chart part of my pivot chart to show the data row names to be more descriptive than the abbreviated data row names in the source.
    attached is my data, in sheet 1, the data is in green with the corresponding pivot table.

    for example on my data row of LL this stands for LEVEL LEVEL which is what i would like , ideally, on my chart.
    i cant really change the source data to LEVEL LEVEL as i would receive it in abbreviated form in future.

    please do reply if im not making sense, but basically on the chart, the name labels of LL,SW, etc above the 0, i would like to change their name

    i have searched elsewhere , you tube , etc, but am getting just how to change headings, legend, name etc.

    so much thanks for any help whom may know an answer to this

    steve
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,814

    Re: Getting chart data labels to be different to the label on the pivot table

    Pivot charts are good when they work, but they have certain limitations on them -- such as these kind of formatting issues.

    I think the easiest way to achieve this is to change the data in the source data for the pivot table. Probably by adding a helper column to the source table that contains the expanded axis label you want to use. Then use that column in your pivot table instead of the abbreviated column. The chart, naturally, will follow right along.

    If you decide that you just cannot change the source data to include the desired expanded text, then you will need to add that text from somewhere outside of the pivot table, which means you cannot use a pivot chart. You will need to start with this tutorial (https://peltiertech.com/regular-char...-pivot-tables/ ) that describes how to make a normal chart from a pivot table. Then you will have the added flexibility to add a dummy series and label it or to use a range outside of the pivot table for the vertical category axis labels or other strategy for adding different text to the axis.

    How would you like to proceed?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    07-07-2019
    Location
    london
    MS-Off Ver
    2013
    Posts
    105

    Re: Getting chart data labels to be different to the label on the pivot table

    Many thanks, ill think ill just leave the table with abbreviated data labels. i cannot change the source data, but i will look into a helper column. i guess that will identify the abbreviated data, e.g LL and change it automatically to LEVEL LEVEL. thanks for help

+ 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. Pivot Table Chart not updating data labels?
    By kjnjanx in forum Excel General
    Replies: 3
    Last Post: 04-27-2019, 04:15 AM
  2. Pivot Chart not displaying data label values for the first Legend label
    By zykkzxxy789077 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-24-2016, 05:46 AM
  3. How to Bring Column labels dynamically to pivot table as the column label is changed
    By JAIGANESH308 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2016, 05:26 AM
  4. Formatting Row Labels in Pivot Table/Chart
    By Pauleyb in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-30-2014, 04:53 PM
  5. Change chart/pivot table numeric labels to associated text labels
    By petschek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 05:32 PM
  6. Replies: 0
    Last Post: 07-03-2012, 11:09 AM
  7. Pivot Pie Chart Data Label renaming
    By matpj in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-22-2007, 12:07 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