Another option would be to concatenate your ID numbers and dates together
into one X-Axis range as opposed to two. For example, given your ID numbers
in column A and your dates in column B, add a formula similar to the one
below into column C:
=B1&" | "&TEXT(A1,"dd/mm/yy")
Then reference your X-Axis off of column C.
--
John Mansfield
http://cellmatrix.net
"BillO" wrote:
Hi
I am doing a line chart and would like two labels for the x axis
accompanying the same data point. The problem I am having is the formatting
of the labels. I would like to fit them in both with the same orientation
(vertical). But only one label goes vertical when I do this. There is a
column for one label (date), and another for ID (which is a #).
thanks