Thread: Pivotchart shows the addition of multiple bars

Hi,

if you please open the "Pivotchart" spread sheet in the attached excel file, the chart comes from the "early cash flow" spread sheet data.

in the chart, when I chose the options from the right dropdown details, i'd like to have another bar showing the sum of multiple chosen bars. For example, by choosing "Mgt Reverse" ( which is a NEGATIVE value) and "JV cost" ( which is a Positive value), may I have a bar on beside with the sum of them. As you may see in the attached jpg file, may I have any chance to have a bar with the value of below beside them for example:
(+588883168 - 30784317 ) = 55809885 ?

This is the first time i'm joining to the excel forum, i hope my question is quite informative and breif.

I appreciate your time and looking forward your kind answer
thanks
Ali Razavi