Different kinds of data on chart
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.
|