We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how to display zero values in charts

asked 2019-07-17 17:11:45 +0200

Terrenium gravatar image

updated 2020-07-22 13:15:19 +0200

Alex Kemp gravatar image

I have a series of bar charts that I am displaying for cumulative statistics showing organic chemical components. Some of these have a value of 0.0 and it is desirable to show this. As an example, if an element 'x-desy3-9' has a blue color legend, and it's value is 0.0 grains in the excel column, I would like to show a "flat square" of blue on the floor of the chart. For some reason, I cannot get this to display. Thanks for any input you can offer.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-18 21:50:41 +0200

erAck gravatar image

Well, a height of 0 when viewed from the side is nothing, so use a 3D look column chart.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-17 17:11:45 +0200

Seen: 240 times

Last updated: Jul 18 '19