View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
macroapa macroapa is offline
external usenet poster
 
Posts: 14
Default 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.