Negative Value in Excel Pivot Table to be Charted as Positive in Pivot Chart

[sk2018]

Hi all,
from my source data - one of the columns is shown as negative number.

And I pulled it to be in pivot table and change the formatting to be shown as positive.

Now - when I'm using pivot table to do pivot chart. It is still showing as negative number in pivot chart.

What is the way for me to show it as positive number in pivot chart?

trying to avoid adding new field if possible. Thanks.

 

[Alex Blakenburg]

If you don't want to use a helper column in the source table an option might be to use a calculated field eg.
(PivotTable Analyze > Fields, Items & Sets > Calculated Field ...... create a field that is negative of the original field)

Book7
	A	B	C	D	E	F	G
1	Product	Sales	Returns		Sum of Returns Positive
2	Apple	1500	(100)		Product	Total
3	Orange	2500	(200)		Apple	100
4	Pear	3500	(300)		Pear	300
5					Orange	200
6					Grand Total	600
7
Sheet1

 

[sk2018]

If you don't want to use a helper column in the source table an option might be to use a calculated field eg.
(PivotTable Analyze > Fields, Items & Sets > Calculated Field ...... create a field that is negative of the original field)

Book7
	A	B	C	D	E	F	G
1	Product	Sales	Returns		Sum of Returns Positive
2	Apple	1500	(100)		Product	Total
3	Orange	2500	(200)		Apple	100
4	Pear	3500	(300)		Pear	300
5					Orange	200
6					Grand Total	600
7
Sheet1

View attachment 81968

this works perfectly fine.

Thanks, Alex.

Happy New Year!

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.
Happy New Year to you too.