What type of graph are you plotting?

Select the axis of the data that you want to change- by clicking on the
axis (two
squares should appear on either side of the axis)- Not the data
series... either double click or right click and select 'Format Axis'.
This brings up a pop-up form, go to the scale tab. On the bottom of the
form there are three check boxes, select the middle box- categories in
reverse order. That should work-
if not please let me know-
If you'd like to use code to do it- see below, the line in blue is the
relevant one in the with block.
cheers,
pim

ActiveSheet.ChartObjects(1).Activate
With ActiveChart.Axes(xlCategory)
.CrossesAt = 1
.TickLabelSpacing = 1
.TickMarkSpacing = 1
.AxisBetweenCategories = True
.ReversePlotOrder = True
.MajorTickMark = xlOutside
.MinorTickMark = xlNone
.TickLabelPosition = xlLow
End With


--
Pim
------------------------------------------------------------------------
Pim's Profile: http://www.excelforum.com/member.php...o&userid=27565
View this thread: http://www.excelforum.com/showthread...hreadid=470926