Hide values on a chart but still show the data?

[Kenny100]

Hi Folks

I have a chart showing a range of data:

Place(x) Value
Site1 10
Site2 15
Site3 16
Site4 8
Site5 5
Site6 10
Site7 5
... ..

I'd like to be able to show all 'Place' values on the chart but 'hide' the names of the values. See the following example of what I'm trying to do:

20|
| **
15| ** **
| ** **
10| ** ** ** **
| ** ** ** ** **
5| ** ** ** ** ** ** **
| ** ** ** ** ** ** **
0|__**____**____**___**____**____**____**___
Site1 Site2 Site4 Site5 Site7

Here Site3 and Site6 have been hidden but their values are still shown. Is this possible?

Cheers!

 

[Kenny100]

Sorry folks, the graph SHOULD have looked more like this!!!

20|
| **
15| ** **
| ** **
10| ** ** ** **
| ** ** ** ** **
5 | ** ** ** ** ** ** **
| ** ** ** ** ** ** **
0 |__**____**____**___**____**____**____**___
Site1 Site2 Site4 Site5 Site7

 

[lbass]

This might depend on your version, but in 8.0, if you go to the chart analyzer->format grid->group axis->labels, you can check "Use manual number of groups between labels" or check "Stagger labels"--but you do not have the option of conditionally formatting this to what you are showing above, which appears to suppress every third label. Maybe you do in higher versions, I don't know.

-LB