It still does now show the P's as a line based on Date as the X axis

"Peter Ellis" wrote:

Create the chart. Then apply filters (Data menu | Filter | AutoFilter) to
the table with the data. Then apply your filter to the table to show only
the P values. The chart will update accordingly.

Place the chart just below the data table to see the effect before moving
the chart to its own worksheet.


"Michelle" wrote:

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....