Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
bumin
Partner - Creator II
Partner - Creator II

How can I show only every 10th value on x axis?

Hi,

I have big chart with 600 values on the x axis.

is is possible to show only every 10th value, so I will have only 60 values on th x axis als legend

thanks

Bumin

1 Solution

Accepted Solutions
Anonymous
Not applicable

You could try this :

  • Create an additional expression with an IF statement to only display the Dim values you want
    • = if ( Dim = 'B' , Dim , ''  )
    • This will only show where Dim is B, you'll need to sort your own logic here for every 10th value
  • For this expression tick Text on Axis and untick all other Display Options
  • For the Dimension untick Show Legend
  • You may need to use <Ctrl><Shift> to move / resize your Chart sub objects.

View solution in original post

12 Replies
maxgro
MVP
MVP

did you already try to uncheck stagger labels in axis tab? you get few values on x-axis (maybe not only every 10th)

bumin
Partner - Creator II
Partner - Creator II
Author

Hi Massimo,

I have uncheked "stagger labels". But still I have the same number of values on the x axis legend

marcus_sommer

Within the tab presentation (top right) is an option to limit the count of x-axis values with a possibility to use an scrollbar.

- Marcus

bumin
Partner - Creator II
Partner - Creator II
Author

but it want to see all values on one view.

I just want to show less legend on the x axis

maxgro
MVP
MVP

this is what I get with unchecked/checked stagger

1.png

bumin
Partner - Creator II
Partner - Creator II
Author

yes you are rigth. It shows less

Anonymous
Not applicable

You could try this :

  • Create an additional expression with an IF statement to only display the Dim values you want
    • = if ( Dim = 'B' , Dim , ''  )
    • This will only show where Dim is B, you'll need to sort your own logic here for every 10th value
  • For this expression tick Text on Axis and untick all other Display Options
  • For the Dimension untick Show Legend
  • You may need to use <Ctrl><Shift> to move / resize your Chart sub objects.
bumin
Partner - Creator II
Partner - Creator II
Author

very nice solution , thanks

Anonymous
Not applicable

I have found it useful, when I wish display data at daily granularity, but label it monthly.

Also by using the GetPossibleCount() function on your dimension you can get it to flex how many labels are displayed for the number of data points.