Ah, now I know what you want.

Put your data in the sheet like this:

N P
1/1/05 6 3
1/2/05 4 1
1/3/05 2 3

(The order of N and P doesn't matter.) Select the data and make a line or xy
chart. You will get a chart with regular markers connected by lines, with a
legend off to the side. To use the N and P as point markers, double click
each series in turn, and on the patterns tab, select a large square for the
marker (use a size of 10, give or take), and use the same color for marker
foreground and background that matches the plot area fill. On the data
labels tab, choose series name for the label content. After pressing OK,
double click on the markers, and on the alignment tab, choose the 'center'
label position.

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


"Michelle" wrote in message
...
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....