Bar and Line Graph Combo

  • Thread starter Thread starter Jim R.
  • Start date Start date
J

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
 
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
 
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.
 
Back
Top