Thread: Line Chart

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

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

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

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" <Michelle@discussions.microsoft.com> wrote in message
news:0A85D2C5-67DE-43D4-8F35-95C6DD78C7B0@microsoft.com...
>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....

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" <Michelle@discussions.microsoft.com> wrote in message
> news:0A85D2C5-67DE-43D4-8F35-95C6DD78C7B0@microsoft.com...
> >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....
>
>
>

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" <Michelle@discussions.microsoft.com> wrote in message
news:D549D894-9B32-48D0-A88C-9DE487C47171@microsoft.com...
>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" <Michelle@discussions.microsoft.com> wrote in message
>> news:0A85D2C5-67DE-43D4-8F35-95C6DD78C7B0@microsoft.com...
>> >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....
>>
>>
>>