I would like the dates across the X and numbers on the Y with the P's as a
point.
(a little hard to show on here)
example....
Say on 1.1.05 you have 3 P's and 6 N's then on 1.2.05 there is 1 P's and 4
N's on 1.3.05 you have 3 P's and 2 N's

7

6 N
\
5 \
\
4 N
\
3 P \ P
\ \/
2 \ / N
\ /
1 P

1.1.05 1.2.05 1.3.05 etc.

"Jon Peltier" wrote:

How do you want the chart to display the P's?

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


"Michelle" wrote in message
...
I have an excel sheet that has dates and P for positive or N for Negative
on
a given person for that date...how can I make a chart that would show the
trend of the P's for lets say a year. The sheet is set up as follows.
Emp # Date Pos/Neg
12345 1/1/05 P
23456 1/1505 P
34567 6/15/05 N
etc....