(Very sorry for the double-post to two NG - I forgot about this NG
until after I posted to the other!)

I'm trying to re-create a chart I had in XL2003, but in XL2007 the
dialog boxes have changed just a bit and I'm lost!

I have four trailers that accumulate miles, and I need to chart the
number of failures for tires and shocks on both the left and right
side of each trailer. So I have named ranges: Miles_A, _B, _C, and
_D, LTires_A etc, RTires_A etc, LShocks_A etc and RShocks_A etc. I
want Miles across the bottom, and the number of failures per item on
the vertical axis.

Insert Chart Line Stacked with Markers
Select Data Sheet1!LTires_A

and from there I am lost!! I can't get the horizontal axis to format
because I can't find the options to set the Min, Max, and Interval.
I
can't make XL2007 understand that I want the miles for all shown
across the bottom.

I miss the old Chart Wizard where I could define the X and the Y for
each data series in one swoop!! How can I make this happen in
XL2007?

Ed

Ed from AZ -

I already provided a terse reply in microsoft.public.excel:

Use an XY(Scatter) chart type.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"Ed from AZ" wrote in message
...
(Very sorry for the double-post to two NG - I forgot about this NG
until after I posted to the other!)

I'm trying to re-create a chart I had in XL2003, but in XL2007 the
dialog boxes have changed just a bit and I'm lost!

I have four trailers that accumulate miles, and I need to chart the
number of failures for tires and shocks on both the left and right
side of each trailer. So I have named ranges: Miles_A, _B, _C, and
_D, LTires_A etc, RTires_A etc, LShocks_A etc and RShocks_A etc. I
want Miles across the bottom, and the number of failures per item on
the vertical axis.

Insert Chart Line Stacked with Markers
Select Data Sheet1!LTires_A

and from there I am lost!! I can't get the horizontal axis to format
because I can't find the options to set the Min, Max, and Interval.
I
can't make XL2007 understand that I want the miles for all shown
across the bottom.

I miss the old Chart Wizard where I could define the X and the Y for
each data series in one swoop!! How can I make this happen in
XL2007?

Ed