Showing negative values in a chart

[Krinsom]

Hi Chandoo,

First of all I´d like to say that your web site is absolutely marvelous and it has helped me a lot!

I have some data that I need to plot a chat showing just one serie at time, just like this sample (http://peltiertech.com/WordPress/display-one-chart-dynamically-and-interactively/).

The matter is that when I apply the cell formatting (0;; it hides the negative values, and I DO NEED the negative values.

How do I fix it?

Thanks a lot


Mario

 

[keymaster]

Mario, thanks for the compliments.


Instead of using 0;;; as the code, try using 0;-0;; and you will see both negative and positive values in data labels. The only problem is that, if you data does have zeros, they will not be shown. But I guess that is alright.


Also, there is a mistake in the url, it should be http://peltiertech.com/WordPress/display-one-chart-dynamically-and-interactively/

 

[Krinsom]

Thank you, Thank you, thousand times thank you.


Cheers


Mario