+ Reply to Thread
Results 1 to 3 of 3

Hide Columns in a Pivot Chart

  1. #1
    Registered User
    Join Date
    06-24-2012
    Location
    Argentina
    MS-Off Ver
    Excel 2010
    Posts
    15

    Hide Columns in a Pivot Chart

    I'm working on the metrics from my team.
    I need to show in a line chart only the success rate of the changes.
    I have created the table and the pivot chart.

    Now, I would like to know how to hide the unsuccessful lines from the chart?? Without filtering the columns from the pivot table.

    table_example.xlsx

    I have attached a copy of the pivot table and a copy from the the chart. So that is not the actual info.
    If you see the chart, I need to hide the "No impact - Backed out" and "No impact - Not backed out" lines from the chart without affecting the success line.

    Thanks

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Hide Columns in a Pivot Chart

    You might need use formula to control the visibility of the chart data. See attached for example.
    Attached Files Attached Files

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Hide Columns in a Pivot Chart

    You can make the lines invisible by clicking on the data line in the char then right click and choose Format Data Series, Choose Line Color and set the Transparency to 100%. Do this for both series and the lines will be invisible even though they are still there.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Hide Series In Pivot Chart, Not in Pivot table
    By jmcconville18 in forum Excel General
    Replies: 0
    Last Post: 06-26-2014, 08:57 AM
  2. Hide a chart (non pivot) when there is no data
    By Panfergrrl18 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-27-2013, 01:27 AM
  3. [SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)
    By Gideon1973 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2012, 10:57 AM
  4. Replies: 0
    Last Post: 06-02-2009, 12:29 AM
  5. Pivot Chart - hide series field
    By uncleslinky in forum Excel General
    Replies: 0
    Last Post: 04-28-2009, 12:44 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