Hi,

Double click the x axis and on the scale tab alter the value for 'Number
of categories between tick-mark labels'. But with 1200 labels you may
have trouble reading any if you display all of them.

Cheers
Andy

ah wrote:
I have a spreadsheet 1200 rows long. I traced a line chart (for
representing the information present in column C) using the wizard and would
like now to label the x axis using the information scattered in column B.
In source data, I indicate for Category x axis: label =Sheet1!$B$1:$B$1200
but only the first label appears.

I tried to do exactly the same on a small spreadsheet (20 rows) and it
worked well, my x axis was correctly labelled but it does not work on a long
spreadhseet. What am I doing wrong?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info