On Tue, 1 May 2007, in microsoft.public.excel.charting,
BillO said:
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 #).

Yes, that's a problem with having two labels on the X axis.

Are you prepared to go radical and abandon the Microsoft-provided axis
facility? If so, you can create your own customised X axis with all the
properties you want, by creating a data series, labelling it, and
formatting it to look like an axis. For two labels you either want a
specially-formatted label, or more likely two series.

Have a look at the "Arbitrary axis" examples on Jon Peltier's "Chart
Axes and Axis Tricks" page:

http://peltiertech.com/Excel/Charts/axes.html#ArbAxis

Tushar Mehta's "Flexible log scale" tutorial is about Y axes, but the
principles are the same, and it may help you if you get stuck.

http://www.tushar-mehta.com/excel/ne...ble_log_scale/

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.