One for the chart wiz kids
 

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

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

One for the chart wiz kids
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ps.com...
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