3 data stock graph with average

[macroapa]

Hi,

I have a data table for a dept based on quality assessment scores:

Name Min Max Avg
Steve 2 5 3
Dave 10 20 11

I also know that the departmental average is (say) 8

I have the data presented using a stock graph to show each member of
staff with a veritcal line showing the min to max and then a point in
this line showing the persons average.

What I want to do is overlay a straight horizontal line to represent
the department average.

Is this possible?

Thanks.

 

[Jon Peltier]

This is certainly possible. A stock chart is really just a line chart under
the covers. Add an XY series as described in this link:

http://peltiertech.com/Excel/Charts/AddLine.html

 

[Jon Peltier]

This is certainly possible. A stock chart is really just a line chart under
the covers. Add an XY series as described in this link:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon