Results 1 to 4 of 4

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

Threaded View

  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.

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