Mixing scatter plot with a category plot

[Janet A. Thompson]

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.

 

[Herbert Seidenberg]

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

 

[Herbert Seidenberg]

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