Add Target Line To Pivot Chart

**Justair07** · 05-23-2013, 02:41 PM

Hello,

I'm really really stuck on a frustrating issue and can not seem to find a solution. Any help would be greatly appreciated! What I want to do seems simple but I just can't get it to work. I'm trying to create a pivot graph with a target line set at "50" across the entire graph. It has to be a pivot graph because the data will change often and needs to be manipulated by people who are less familiar with Excel than myself.

I attached an example but you will see that my target is not displayed as a horizontal line but instead it's simply just another bar.

Thank you in advance to anyone that can assist me!

- Justin

**Melvinrobb** · 05-23-2013, 03:02 PM

You have to add the Target to the Row headers of the data, and then add it to the column headers of the pivot table.

**Justair07** · 05-23-2013, 03:13 PM

Please excuse my ignorance but i'm confused beacuase I dont even see Target in the PivotTable Field List. where did it go?

**Melvinrobb** · 05-23-2013, 03:15 PM

It is no longer a field. It is an entry under "Week Ending Date". So instead of having only "5/31/2013" selected, you would select "Target" as well.

**Justair07** · 05-23-2013, 03:16 PM

sorry, I see it! it's been a long day, Thank you for your help!!

**uguadarr** · 01-31-2014, 06:37 PM

Is there a way to stretch the trendline so that it doesn't cut off on each side?

**arlu1201** · 02-03-2014, 01:58 AM

uguadarr,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.