+ Reply to Thread
Results 1 to 4 of 4

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

Hybrid View

tstackhouse10 Include only one measure as... 06-27-2019, 11:17 AM
JeteMc Re: Include only one measure... 07-01-2019, 12:01 PM
tstackhouse10 Re: Include only one measure... 07-01-2019, 12:08 PM
JeteMc Re: Include only one measure... 07-01-2019, 06:59 PM
  1. #1
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,867

    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.

  2. #2
    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.

+ 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