3 data stock graph with average
 

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.

3 data stock graph with average
 

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

"macroapa" wrote in message
...
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.

3 data stock graph with average
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"macroapa" wrote in message
...
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.