Positive and negative values in Mekko

[nehasaxena]

Hi All,

I have requirement to create a mekko chart to show the differences. But there are negative values for some of the differences and Mekko chart is not working, it display message ' Positive and negative values'

Please suggest me is it possible to display negative values in mekko chart and how?

Thanks,

Regards,

Neha

[danieloberbilli]

Spontaneously I could not image how a mekko chart with pos and neg. values should look like.

Did you try to visualize it in Excel? I think its the wrong type of chart for that data

[danieloberbilli]

in the case the negative values should (visually) equal zero ...you might try something like if(sum(F1))<0, 0)