Forum Discussion
Rorrre
Apr 20, 2021Copper Contributor
Charts
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.
- Riny_van_EekelenPlatinum Contributor
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.