• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Showing negative values in a chart


New Member
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



New Member
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/