two category axes?

[fredrp]

I have 3-column data like this.

STUDENT are the names of students, N is a level at which each is at,
and LABEL is the name of that level.

I want to produce a bar chart of N where the y-axis comes from STUDENT,
like this.

but I want to label the x-axis with the values from LABEL. Can't see how to
do that. Help please?

thanks
fred
san rafael, ca

[Andy Pope]

You can not plot those Labels, in column C, directly.

You will need to make a table of labels for each value 1 to 7.
Include in this table a blank record at the top and bottom.

Create your bar chart as normal.

Add another data series.
Change to Line chart.
Set data source to table of labels and zeros.
Remove Tick mark labels from primary value axis
Set tick mark labels to low for seconadry value axis.
Set crosses between categories for secondary value axis.