Mixing scatter plot with a category plot
 

How do you combine a scatter plot (showing numbers on axis) with a category
plot (showing categories) and a line graph that is within the area of the
category plot?
Can Excel 2007 do this and how? All the source data is in one worksheet.
--
Janet A.

Mixing scatter plot with a category plot
 

Excel 2007 Chart
Combine XY and Column Series.
Primary with category, secondary with numbers.
http://www.mediafire.com/file/jlwecvcnkik/03_24_10.xlsx

Mixing scatter plot with a category plot
 

Excel 2007 Mixed Line/Bar Chart
Another example:
http://c0718892.cdn.cloudfiles.racks...03_24_10a.xlsm