Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
in the case the negative values should (visually) equal zero ...you might try something like if(sum(F1))<0, 0)