+ Reply to Thread
Results 1 to 4 of 4

Include only one measure as part of a Pivot Chart/Table

  1. #1
    Registered User
    Join Date
    12-13-2016
    Location
    Altoona, PA
    MS-Off Ver
    2016
    Posts
    9

    Include only one measure as part of a Pivot Chart/Table

    Currently, I have a Pivot table and chart that shows Filled Lines, Unfilled Lines and Partial Lines. I need to see Unfilled Lines as a percentage of all lines. In my pivot table, I right click my line count and go into Value Field Setting and change "Show Vales As" to "Percent of Row Total". This give me the percentages that I am looking for. However, I want a chart displaying only Unfilled Lines percentage.
    I the attached workbook I have a pivot chart but I need it to only show unfilled lines. I have attempted to delete the 'Filled Lines' Line but it just changes the color.

    I have an underlying SQL query that updates this every month so copy and pasting and creating another chart is not an option.
    Attached Files Attached Files
    Last edited by tstackhouse10; 07-01-2019 at 12:09 PM.

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

    Re: Include only one measure as part of a Pivot Chart/Table

    Perhaps the following will help although I don't know if the query updates will have an affect as I am unfamiliar with them
    1. Select the Filled line on the graph and change the data series to plot on the secondary axis
    2. Change the line option to no line
    3. Change the line option for the partial line to no line
    4. Change the text options of the secondary axis to no fill
    5. [optional] Delete the legend
    6. [optional] Put the chart title "Unfilled Lines" above the chart.
    Let us 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
    Registered User
    Join Date
    12-13-2016
    Location
    Altoona, PA
    MS-Off Ver
    2016
    Posts
    9

    Re: Include only one measure as part of a Pivot Chart/Table

    Thank You!! This will work for me. Very ingenuitive way to solve this... never would have thought of that.

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

    Re: Include only one measure as part of a Pivot Chart/Table

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed 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. pivot table with DAX measure
    By mlaxx in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-12-2019, 02:24 PM
  2. Data Model Pivot Table - Measure Issue
    By CraigsWorld in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-29-2018, 02:54 AM
  3. Pivot Table Calculation (Measure) Formula Help
    By sovietchild in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-21-2018, 10:31 AM
  4. Power Pivot: Adding a measure to a Pivot Chart
    By jlt199 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-22-2017, 12:40 PM
  5. [SOLVED] How to include Column out of Pivot Table in Chart
    By toci in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-12-2015, 09:40 AM
  6. Powerpivot Calculated Measure to remove blanks from pivot table/chart
    By hbusche in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-17-2013, 01:23 PM
  7. Replies: 1
    Last Post: 03-28-2013, 11:31 AM

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