|  | Need quick primer on charts in XL2007, please? | | |
| | | Ed from AZ |  |
|  Posted: Tue Sep 02, 2008 6:16 pm Post subject: Need quick primer on charts in XL2007, please? |  |
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 |
| |
| | | Mike Middleton | |
| | Posted: Tue Sep 02, 2008 6:16 pm Post subject: Re: Need quick primer on charts in XL2007, please? | |
| |  | |
Ed from AZ -
If the data are numerical values for both axes, use an XY (Scatter) chart
type.
- Mike Middleton
LINK
Decision Analysis Add-ins for Excel
"Ed from AZ" <prof_ofwhat@yahoo.com> wrote in message
news:43fc34a6-95ff-49c3-951d-ac1944f66e98@m36g2000hse.googlegroups.com...
| Quote: | 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 | |
| | Posted: Wed Sep 03, 2008 2:07 pm Post subject: Re: Need quick primer on charts in XL2007, please? | |
| | | |
Okay - that chart type helped. I also saw that if I use the Add
button, I can put in both the X and the Y at the same time.
Why do they fix things that aren't broke??!?
Ed
On Sep 2, 12:53 pm, "Mike Middleton" <m...@mikemiddleton.com> wrote:
| Quote: | Ed from AZ -
If the data are numerical values for both axes, use an XY (Scatter) chart
type.
- Mike LINK
Decision Analysis Add-ins for Excel
"Ed from AZ" <prof_ofw...@yahoo.com> wrote in messagenews:43fc34a6-95ff-49c3-951d-ac1944f66e98@m36g2000hse.googlegroups.com...
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- Hide quoted text -
- Show quoted text - |
|
| |
|
|
