Different kinds of data on chart

I've been told by my boss that I need to create a chart that shows the
accident rate per million vehicles entering an intersection and the ranking
of that intersection when adjusted for volume. If I just put the straight
values in, I get a chart with a wildly fluctuating ranking (values range from
0 to 186) and almost a straight line at the bottom of the chart for rate per
million (values range from 0 to 2.062). Is there any way to do this that
would produce a better looking chart?

Thanks so much.

Michael, The quick and dirty way would be to plot the accident rate on
the second y axis.
there are other options depending on your ability and LOE that you are
willing to invest.

HTH,
Will


Michael J. wrote:
> I've been told by my boss that I need to create a chart that shows the
> accident rate per million vehicles entering an intersection and the ranking
> of that intersection when adjusted for volume. If I just put the straight
> values in, I get a chart with a wildly fluctuating ranking (values range from
> 0 to 186) and almost a straight line at the bottom of the chart for rate per
> million (values range from 0 to 2.062). Is there any way to do this that
> would produce a better looking chart?
>
> Thanks so much.

Michael, The quick and dirty way would be to plot the accident rate on
the second y axis.
there are other options depending on your ability and LOE that you are
willing to invest.

HTH,
Will


Michael J. wrote:
> I've been told by my boss that I need to create a chart that shows the
> accident rate per million vehicles entering an intersection and the ranking
> of that intersection when adjusted for volume. If I just put the straight
> values in, I get a chart with a wildly fluctuating ranking (values range from
> 0 to 186) and almost a straight line at the bottom of the chart for rate per
> million (values range from 0 to 2.062). Is there any way to do this that
> would produce a better looking chart?
>
> Thanks so much.

Thanks for the response. Could you give me a quick lesson in how to plot the
accident rate on the second y axis?

"[email protected]" wrote:

> Michael, The quick and dirty way would be to plot the accident rate on
> the second y axis.
> there are other options depending on your ability and LOE that you are
> willing to invest.
>
> HTH,
> Will
>
>
> Michael J. wrote:
> > I've been told by my boss that I need to create a chart that shows the
> > accident rate per million vehicles entering an intersection and the ranking
> > of that intersection when adjusted for volume. If I just put the straight
> > values in, I get a chart with a wildly fluctuating ranking (values range from
> > 0 to 186) and almost a straight line at the bottom of the chart for rate per
> > million (values range from 0 to 2.062). Is there any way to do this that
> > would produce a better looking chart?
> >
> > Thanks so much.
>
>

Thanks for the response. Could you give me a quick lesson in how to plot the
accident rate on the second y axis?

"[email protected]" wrote:

> Michael, The quick and dirty way would be to plot the accident rate on
> the second y axis.
> there are other options depending on your ability and LOE that you are
> willing to invest.
>
> HTH,
> Will
>
>
> Michael J. wrote:
> > I've been told by my boss that I need to create a chart that shows the
> > accident rate per million vehicles entering an intersection and the ranking
> > of that intersection when adjusted for volume. If I just put the straight
> > values in, I get a chart with a wildly fluctuating ranking (values range from
> > 0 to 186) and almost a straight line at the bottom of the chart for rate per
> > million (values range from 0 to 2.062). Is there any way to do this that
> > would produce a better looking chart?
> >
> > Thanks so much.
>
>

Sure... Right Click the series and choose [Format Data Series] In the
dialog box choose the [Axis] tab and click on the "Plot Series on
Secondary Axis" radio button.
-Will

Michael J. wrote:
> Thanks for the response. Could you give me a quick lesson in how to plot the
> accident rate on the second y axis?
>
> "[email protected]" wrote:
>
> > Michael, The quick and dirty way would be to plot the accident rate on
> > the second y axis.
> > there are other options depending on your ability and LOE that you are
> > willing to invest.
> >
> > HTH,
> > Will
> >
> >
> > Michael J. wrote:
> > > I've been told by my boss that I need to create a chart that shows the
> > > accident rate per million vehicles entering an intersection and the ranking
> > > of that intersection when adjusted for volume. If I just put the straight
> > > values in, I get a chart with a wildly fluctuating ranking (values range from
> > > 0 to 186) and almost a straight line at the bottom of the chart for rate per
> > > million (values range from 0 to 2.062). Is there any way to do this that
> > > would produce a better looking chart?
> > >
> > > Thanks so much.
> >
> >

Thanks a lot...that worked perfectly!

"[email protected]" wrote:

> Sure... Right Click the series and choose [Format Data Series] In the
> dialog box choose the [Axis] tab and click on the "Plot Series on
> Secondary Axis" radio button.
> -Will
>
> Michael J. wrote:
> > Thanks for the response. Could you give me a quick lesson in how to plot the
> > accident rate on the second y axis?
> >
> > "[email protected]" wrote:
> >
> > > Michael, The quick and dirty way would be to plot the accident rate on
> > > the second y axis.
> > > there are other options depending on your ability and LOE that you are
> > > willing to invest.
> > >
> > > HTH,
> > > Will
> > >
> > >
> > > Michael J. wrote:
> > > > I've been told by my boss that I need to create a chart that shows the
> > > > accident rate per million vehicles entering an intersection and the ranking
> > > > of that intersection when adjusted for volume. If I just put the straight
> > > > values in, I get a chart with a wildly fluctuating ranking (values range from
> > > > 0 to 186) and almost a straight line at the bottom of the chart for rate per
> > > > million (values range from 0 to 2.062). Is there any way to do this that
> > > > would produce a better looking chart?
> > > >
> > > > Thanks so much.
> > >
> > >
>
>

Sure... Right Click the series and choose [Format Data Series] In the
dialog box choose the [Axis] tab and click on the "Plot Series on
Secondary Axis" radio button.
-Will

Michael J. wrote:
> Thanks for the response. Could you give me a quick lesson in how to plot the
> accident rate on the second y axis?
>
> "[email protected]" wrote:
>
> > Michael, The quick and dirty way would be to plot the accident rate on
> > the second y axis.
> > there are other options depending on your ability and LOE that you are
> > willing to invest.
> >
> > HTH,
> > Will
> >
> >
> > Michael J. wrote:
> > > I've been told by my boss that I need to create a chart that shows the
> > > accident rate per million vehicles entering an intersection and the ranking
> > > of that intersection when adjusted for volume. If I just put the straight
> > > values in, I get a chart with a wildly fluctuating ranking (values range from
> > > 0 to 186) and almost a straight line at the bottom of the chart for rate per
> > > million (values range from 0 to 2.062). Is there any way to do this that
> > > would produce a better looking chart?
> > >
> > > Thanks so much.
> >
> >

Thanks a lot...that worked perfectly!

"[email protected]" wrote:

> Sure... Right Click the series and choose [Format Data Series] In the
> dialog box choose the [Axis] tab and click on the "Plot Series on
> Secondary Axis" radio button.
> -Will
>
> Michael J. wrote:
> > Thanks for the response. Could you give me a quick lesson in how to plot the
> > accident rate on the second y axis?
> >
> > "[email protected]" wrote:
> >
> > > Michael, The quick and dirty way would be to plot the accident rate on
> > > the second y axis.
> > > there are other options depending on your ability and LOE that you are
> > > willing to invest.
> > >
> > > HTH,
> > > Will
> > >
> > >
> > > Michael J. wrote:
> > > > I've been told by my boss that I need to create a chart that shows the
> > > > accident rate per million vehicles entering an intersection and the ranking
> > > > of that intersection when adjusted for volume. If I just put the straight
> > > > values in, I get a chart with a wildly fluctuating ranking (values range from
> > > > 0 to 186) and almost a straight line at the bottom of the chart for rate per
> > > > million (values range from 0 to 2.062). Is there any way to do this that
> > > > would produce a better looking chart?
> > > >
> > > > Thanks so much.
> > >
> > >
>
>