3 Ways to Add a Target Line to an Excel Pivot Chart

[@paulbullock7196]

Perfect solution using the calculated field!!! Thank you for posting...very helpful!!!

[@exceldashboards]

Glad it was helpful!

[@juliegibson9182]

Exactly what I was looking for - thank you so much! So much safer to use an actual data flied for this, I don't want anyone copying a chart for a report and losing a line that's just overlaid as a shape.

[@exceldashboards]

Thanks for your great comment. Glad to help!

[@managedbywhitney]

Thanks for the 3 ways! New fan of creating a calculated field!

[@exceldashboards]

Awesome! So glad to help. Check out some of the other pivot tips and tricks here: hppts://www.exceldashboardtemplates.com/?s=pivot

[@sanelelushozi6957]

Thanks. This was helpful, just what i was looking for🙏🏽

[@pmsocho]

Target via calculated field - awesome! Thanks for that trick!

[@exceldashboards]

+pmsocho Thanks for the great comment PMSOCHO. Very much appreciated. Steve=True

[@ambientsounds4215]

Hi! Very useful video indeed. Four my dashboard, each salesperson has a different target. Any udea how this might work? Thanksin advance!

[@exceldashboards]

see if this helps. www.exceldashboardtemplates.com/how-to-add-lines-in-an-excel-clustered-stacked-column-chart/

[@2002ritesh]

What if I have Ave of Sales, Ave of cost, ave of commision on same pivot graph, please advise how to get multiple traget lines?

[@jorgearmandoglez]

Thanks, very helpful!! It save me a lot of time.

[@exceldashboards]

You are very welcome. Glad to help!

[@kurtbandy4053]

What if I have multiple numbers with the same target but I don’t want to have three “Average of Target” columns. In your example it could be Referral Sales, Cold Call sales, and Renewals all with a 5,000 target. When I add the Calculated Field Target it adds three new lines to my pivot table.

[@jazzista1967]

Great & smart trick. Calculated field .Thank you Steve=TRUE

[@exceldashboards]

+jazzista1967 You are very welcome. Thanks for the great comment. Steve=True

[@SL-og1qf]

My issue is that I want the average line to be dynamic with the slicers. Can't seem to get that to work?

[@sabeehmashhadani5027]

Thanks, great solutions.

[@exceldashboards]

You are welcome, thanks for the great comment.

[@shockhopful]

THANK YOU SOOOO MUCH!

[@exceldashboards]

You are very very welcome. Thanks for the comment.

[@HarmanSingh-od9xm]

Very very good

[@exceldashboards]

Thanks

[@iRandom_Thoughts]

Thanks , Very useful video

[@exceldashboards]

Thanks Random. I appreciate your nice comments!

[@richsilv]

I have a bit of extra complexity... My chart is a stacked chart... Whenever I follow either of the last two methods, the new data stacks nicely with the other data...

[@exceldashboards]

Hi Rich, does this tutorial help? www.exceldashboardtemplates.com/AddTotalLineStackedColumnChart

[@BlackthorneBay]

When I do either of the 2nd or 3rd methods, I do not get ONE line - I get an extra column next to EVERY column, and then it changes my chart colors and adds way too much useless data to my Axis titles.

[@exceldashboards]

Thanks for the feedback. Perhaps you missed a step. Not sure the exact issue.

[@sarahburch6292]

@@exceldashboards I'm having the same issue with using multiple columns and adding the limit to each column. Any advice on how to add just one limit column when you have multiple columns in the pivot chart.

[@kylejacobs1007]

How would you do it if you were plotting with more data sets: Some background, I am creating a dynamic chart, linked to a dynamic pivot table, linked to a advanced filter by region. Example of how my data is set up as follows: Sales Agent Daily Sales Period Goal John 27 Jan 2016 30 Mike 32 Jan 2016 30 Sara 35 Jan 2016 30 John 37 Feb 2016 30 Mike 29 Feb 2016 30 Sara 37 Feb 2016 30 etc.... When I pivot: Row Lables John(daily Sales) John Goal Mike(daily Sales) Mike Goal etc... Jan 2016 27 30 32 30 Feb 2016 33 30 29 30 etc.... I dont want the goal to repeat over and over.

[@exceldashboards]

Hi Kyle, I am not sure I completely understand. Do you mean if each sales person has a different goal?

[@HarmanSingh-od9xm]

👍👍👍

[@exceldashboards]

Thanks!

[@HarmanSingh-od9xm]

Nyc

[@exceldashboards]

Thanks 🤗

[@George_Tropicana]

you go too fast! and my line is not showing!!!!!!!!!

[@exceldashboards]

Hi Rachel, sorry it is too fast. You can also see a sample file and written steps here: www.exceldashboardtemplates.com/3WaysTargetLinePivotChart That may help you with your issue.