How to show 1 value in chart

Question

Hi there! just want to ask how to show the value 1 in chart?

Thank you in advance!

Best Regards,

Jef

Answer 1

Try setting the lower bound of graph to zero

Answer 2

Hi jefnavarro,

According to your description, you hope the value 1 to be displayed in series. If so, please refer to the following steps to set minimum value of Horizontal Axis to zero:

1. Right click anywhere of Horizontal Axis on the chart and open Horizontal Axis Properties dialog box.
2. In Axis Options pane, in Axis range and interval section, click the expression (fx) button next to Minimum.
3. In the expression text box, type =0, then click OK.

The following screenshots are for your reference:

 
If you have any questions, please feel free to let me know.

Best Regards,
Wendy Fu

Answer 3

Hi jefnavarro,

According to your description, you hope the value 1 to be displayed in series. If so, please refer to the following steps to set minimum value of Horizontal Axis to zero:

1. Right click anywhere of Horizontal Axis on the chart and open Horizontal Axis Properties dialog box.
2. In Axis Options pane, in Axis range and interval section, click the expression (fx) button next to Minimum.
3. In the expression text box, type =0, then click OK.

The following screenshots are for your reference:

 
If you have any questions, please feel free to let me know.

Best Regards,
Wendy Fu

Hi there and good day to you! 

First of all thank you for the clear steps that you share but I don't know why still won't come..

maybe because my horizontal axis is starting from 1 as you can see on the lower part of my screenshot.. how can i set this to 0?

thank you again.

edited:

just want to add that my data is only counting on data in Values [Count(Name)] in chart data maybe that's why i don't have 0 value?

Answer 4

As described above if you set the horizontal axis minimum to 0 it should solve your problem.

Can you post a screenshot of the Axis properties for us?

Answer 5

As described above if you set the horizontal axis minimum to 0 it should solve your problem.

Can you post a screenshot of the Axis properties for us?

i followed the steps mention above but it seems that i don't have 0 value that's why it won't show.