Forum Discussion

Mr_Fong's avatar
Mr_Fong
New Member
7 years ago
Solved

Stacked Column showing too many columns

I have a column chart with 125 fields, however it is showing 140 fields (15 blank) on the chart.  I have tried filtering to "<126" but that does not work:

125 data points

15 blank fields

How can I display the chart with only 125?

Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Mr_Fong ,

     

    On the X-axis options, change the Type from continuous to Categorical this will only show the 125 values, another option is to set the end value of the X-axis to 125 (not the best one).

     

    Regards,

    MFelix

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago

    Hi Mr_Fong ,

     

    On the X-axis options, change the Type from continuous to Categorical this will only show the 125 values, another option is to set the end value of the X-axis to 125 (not the best one).

     

    Regards,

    MFelix

    • Mr_Fong's avatar
      Mr_Fong
      New Member
      7 years ago

      MFelix 

      Changing the X to Categorical did some other weirdness, but limiting the X to 125 worked perfectly! 

       

      Thanks!