ONLYOFFICE Docs v6.4 with conditional formatting, new scaling options, and WOPI protocol support
ONLYOFFICE Docs v6.4 released

How to not display void values in a X-Y chart?

Hello,
I have a secondary set of data, issued from a primary set of data. In the secondary set, I hide some values and replace them by void strings like “” by a formula looking like =IF(first_set_data <> desired figure; “”; desired figure)
The other values are numbers.
When creating a X-Y chart, the void figures appear like having zero value and are displayed as a dot on the X-axis (where Y=0).
In order to avoid having all theses unnecessary dots forming a meaningless or confusing horizontal line at the bottom of the chart, I changed, the lower limit of the vertical axis, via the advanced parameters, setting the lower limit at 0.1 (the upper limit is 1)
Dispite this artefact, the unnecessary dots still appear, below the horizontal axis!
I would like to get a chart feature that does not think better than I do and just does what I want to get.
Thanks in advance for your help !
Michel

Hello Michel,
Please provide some additional information on the issue:

  1. Version of the Document Server you are using.
  2. Example file.

Hello Carl,

Please find an exemple spreadsheet. Concerned chart is in top-left corner of tab Ana_coûts.
OnlyOffice release 6.4.0.121. Nextcloud release 19
Kind regards
Michel