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?

" 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?

" 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!

" 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?

" 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.