Bar and Line Graph Combo

[Jim R.]

I would like to create a bar graph using the Program #1
scores and have Excel draw a line across each bar to
represent the respective All Programs scores. Can this be
done?

This would allow us to see the response over time and
compare it to the All Programs score. The final graph will
have more time periods and more questions. Excel 2000.

Critique Score
Program #1 2002 2003
Question 1 90 94
Question 2 91 93

All Programs 2002 2003
Question 1 88 92
Question 2 92 94

Thanks,

Jim

 

[Jim R.]

Thanks for the suggestions but I think this will make the
chart too busy. This chart will display results from about
10 questins and 4 time periods. Any other suggestions?

Thanks

 

[Debra Dalgleish]

You could use the technique that Jon described, but change the line to
None, and use the horizontal line marker style. Set the marker font size
to about 15, and it should be easily visible.