+ Reply to Thread
Results 1 to 2 of 2

How do I add a target line to a pivot chart with percentages

  1. #1
    Registered User
    Join Date
    03-22-2015
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    42

    How do I add a target line to a pivot chart with percentages

    Hello

    I have a pivot table where I have set the Value Field setting to %. What I'd like to do is be able to add a target line (90%) to my chart. Is this possible? I have attached a screen shot of my pivot chart.

    Thanks for your help.
    Attached Images Attached Images

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

    Re: How do I add a target line to a pivot chart with percentages

    Not saying that I can help, however there isn't a screen shot of a chart attached. Even if there was it would be easier to help if you would upload the workbook from which the attached image in post #1 came. To upload a workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window. Remember to desensitize the data if necessary.
    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.

+ 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. How to add target line to a STACKED COLUMN pivot chart
    By vsraghuraman in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-19-2016, 09:07 PM
  2. Adding a Dynamic "Target Threshold line" to a Pivot table and chart
    By ImokatExcel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-30-2016, 03:02 PM
  3. add a target line to a chart
    By justlearning123 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-26-2015, 05:29 AM
  4. [SOLVED] Add Target Line To Pivot Chart
    By Justair07 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-26-2014, 07:38 AM
  5. How to add target line to stacked column pivot chart chart
    By oleg mirzaev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-04-2013, 07:46 AM
  6. VBA target line using pivot table bar chart
    By Turmoilz in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-28-2013, 05:44 AM
  7. target line in bar chart
    By chinascot69 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-28-2006, 07:55 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