This doesn't work. I need three of the plots to be scaterplots and the fourth
to be an area plot. I can't choose the axis type for just one of the plots,
in either Excel 2003 or 2007.

"MikeM" wrote:

Im plotting (Excel 2007) monthly crime data from 1960-2007 (576 data points)
for USA counties. The crime rate is the crime count divided by the
population. However, not every agency in a county reports every month, and in
some cases they dont report for a number of years.

My plots, therefore, show four lines: total pop (black), reported pop
(green, semitransparent), and crime count x 100 (blue) are all on an
adjustable vertical axis, because counties vary considerably in population
and crime counts. The fourth plot, crime rate (crime count divided by
reported pop, orange), is on a fixed axis, so different counties rates can
be compared. Ive uploaded two figures; theyre at
sociology.osu.edu/mdm/CountyPlots.pdf
To make these plots more readable, Id like to plot the green line as a
solid area in the background. Ive tried to use the €œarea€� chart type for
that plot, but it plots the data as running from 1 to 576, instead of from
20454 (1/1/60) to 37985 (12/31/07).

How can I accomplish this, and in addition how can I make this plot stay in
the background?

TIA,
Mike