Quick primer for charts in XL2007, please?

(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" <prof_ofwhat RemoveThis @yahoo.com> wrote in message
news:f1f52fb5-9f83-4528-8230-d66a62cbcd75@d1g2000hsg.googlegroups.com...
> (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