none
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

    Thursday, September 04, 2014 12:41 PM

Answers

  • 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


    Friday, September 05, 2014 7:06 AM
    Moderator

All replies

  • Try setting the lower bound of graph to zero
    Thursday, September 04, 2014 12:49 PM
  • 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


    Friday, September 05, 2014 7:06 AM
    Moderator
  • 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?

    • Edited by jefnavarro Sunday, September 07, 2014 7:05 AM
    Sunday, September 07, 2014 5:04 AM
  • 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?

    Monday, September 08, 2014 3:20 AM
  • 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.

    Monday, September 08, 2014 5:06 AM