+ Reply to Thread
Results 1 to 3 of 3

Showing Variance in a Pivot Chart

  1. #1
    Forum Contributor
    Join Date
    02-20-2017
    Location
    Indiana
    MS-Off Ver
    2016
    Posts
    101

    Showing Variance in a Pivot Chart

    Hello,

    I'm trying to add variance labels to my pivot chart by adding a variance line and then removing the line and just keeping the data labels. I'm stuck on trying to get the secondary axis to always match the primary axis, even when the chart pivots with the use of slicers. See attachment for details.

    Any help would be appreciated.

  2. #2
    Forum Contributor
    Join Date
    02-20-2017
    Location
    Indiana
    MS-Off Ver
    2016
    Posts
    101

    Re: Showing Variance in a Pivot Chart

    Attachment:
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    02-20-2017
    Location
    Indiana
    MS-Off Ver
    2016
    Posts
    101

    Re: Showing Variance in a Pivot Chart

    Updated Attachment:
    Attached Files Attached Files

+ 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 Chart not showing right values
    By droman in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-14-2017, 01:18 PM
  2. showing variance between amounts in bar graph? please help
    By nimv1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-27-2017, 03:25 AM
  3. Showing Grand totals in a pivot chart
    By i82 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-13-2016, 03:17 AM
  4. [SOLVED] Pivot chart filtered showing subtotal
    By Eemmai in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-05-2012, 05:57 AM
  5. Add a '+' to a formula showing positive variance
    By doowop5000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-08-2007, 09:44 AM
  6. [SOLVED] Pivot Tables - Variance and Variance %
    By PJS in forum Excel General
    Replies: 2
    Last Post: 01-17-2006, 11:15 PM
  7. [SOLVED] Pivot Tables - Variance and % Variance fields
    By CraigS in forum Excel General
    Replies: 5
    Last Post: 01-05-2005, 09:06 PM

Tags for this Thread

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