Charts axis

Dear helpers,

i have established a table where you can choose a number between 0 and 10 by dropdown.
There are two columns. One for the x-axis and the other one for the y-axis. The problem is, that when i choose both times the number 0. Just the y-axis sets its point on zero.
The x-axis remains still at number 1. The settings for both axis are the same. Maybe you can help me with that.
Thank you very much!

Greets Jhonessn

Maybe attach the workbook?

Here it is

Jhonessn said:

Here it is

Click to expand...

Can anybody help me ?

If all the values are zero then all the chart data is text. Therefore the X axis assume x values will be "1"

for the Y data in you chart modify the formula so "keine Eingabe" is replaced with NA()

So the formula in H100, for example would be,

=IFERROR(AVERAGEIF('GRI-Richtlinien "Kern"'!D5356,">0"),NA())

Worked perfectly! Thank you very much!

Greets from Bavaria
Jonas