Occasional Visitor

Hi Guys! How are you?

I would like to know if there's a way to insert a line in a pivot chart to mark a goal. For example, I need to achieve a goal of R$0,54 and I want it to be sinalized in my chart, as shown in the image below, which I drew this line on Paint

If it's not clear enough, let me know.

I'm using Windows 10 and Excel 2012.


2 Replies

@Rorrre You can add a third data series where all data points have the value 0.54 and format it as a red dotted line.


In addition, for PivotChart that's by adding measure and proper chart formatting