Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
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.... |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
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.... |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
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.... |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
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.... |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I link timeline labels to a line chart? | Charts and Charting in Excel | |||
Change line in Chart | Charts and Charting in Excel | |||
Bar Chart To Line Chart for last 3 points only | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |