One for the chart wiz kids

[brian.baker13]

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

 

[Barb Reinhardt]

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

 

[Jon Peltier]

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

- Jon