View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Michael J. Michael J. is offline
external usenet poster
 
Posts: 2
Default Different kinds of data on chart

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.