+ Reply to Thread
Results 1 to 4 of 4

Dynamic labels in a pivot chart?

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Dynamic labels in a pivot chart?

    Hi Forum,

    I have the attahced dataset and wanted to produce a pivot chart in the way explained in the attached.

    Could you please help me.
    Thanks

    Mirisa
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,594

    Re: Dynamic labels in a pivot chart?

    To create the pivot chart in the following file I formatted the Primary and Secondary Y axes, to number with no decimal places and percentage with one decimal place respectively. I also set the secondary y axis so the major axis markers are fixed at 0.1 I changed the series chart type of the Delta data to line, with no line color and selected the appropriate built in line markers under marker options and selected their solid color. I changed the transparency of the Delta data labels to 50%, gave them a color that was a shade lighter than the columns and moved them individually into their appropriate places. I changed the Income data labels to number format with no commas and no numbers after the decimal point, changed their size and moved them individually to the bottom of each column. I changed the column headings in the pivot table to Income and Delta adding an extra space to both so as to make them different from the field names in the original data set. Here is the file with the above mentioned modifications applied.

    Copy of post_this.xlsx

    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: Dynamic labels in a pivot chart?

    Hi JeteMc,
    Your solution is great!
    Thank you so much.

    Mirisa

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,594

    Re: Dynamic labels in a pivot chart?

    You're welcome, and thank you for the feedback. Hope that you have a good day.

+ 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. [SOLVED] Dynamic chart ranges based on formula- Issue on labels
    By james444 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-27-2015, 12:12 AM
  2. Dynamic bubble chart & labels
    By Ztv in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-14-2014, 06:59 AM
  3. 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
  4. [SOLVED] Dynamic display of chart labels
    By kbaruin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-08-2012, 10:25 AM
  5. [SOLVED] Manage x-axis labels in a dynamic chart?
    By tgallag1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-28-2012, 12:20 PM
  6. dynamic pie chart labels not updated with new data
    By Flembo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-13-2009, 07:11 AM
  7. [SOLVED] Dynamic chart labels
    By dano in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-22-2005, 08:05 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