Line Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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/
_______
 
Back
Top