View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default One for the chart wiz kids

I usually put lines like this on charts by plotting one point on the chart
somewhere and then using either a horizontal or vertical error bar for that
point. (I always have to try one and usually it's the other).

IF you have a column with the "target" for each worker. You can add
another series to your chart and then change the series type to LINE.

HTH,

Barb Reinhardt

" wrote:

Hi

I do a weekly quality chart at work for worker performance. This is a
horizontal chart with a bar for each employee with %age on the X scale
& the Operator name on the Y. I want to include two target lines
vertically on the chart for 1 & 1.75%. So far I cannot do this anfd
have to draw two lines down the chart. I have two types of worker one
about 15 of them with a 1.75% target and about 5 workers who have a 1%
target. Could anybody help please.

Thanks

Brian