Hide every other label on y axis for a chart

[Al Delgado]

I would like to clean some clutter on a graph. How would I hide every other y axis label. If the y axis labels are:

70%
60%
50%
40%
30%
20%
10%
0%

I would like to display:

70%

50%

30%

10%
0%

Ideally I would like to get rid of the 0% also.

 

[Hui]

Why not set the Y Axis limits to Min = 0, Max = 0.8
and set the Major Unit to 0.2

 

[Al Delgado]

Well that was simple enough, thanks. What if I wanted to keep all of the grid lines and only show labels for every other grid line?

 

[Debraj]

Using helper Column..

 

[Al Delgado]

Hi, thanks for the help, I wanted to hide every other label for the vertical axis.

 

[NARAYANK991]

Hi ,

See this file.

Narayan

 

[Hui]

Follow My Above steps
and set the Minor Unit to 0.1