Hi, I have a charting question.
I need to make a simple chart of Date vs Time. So Column D vs column E.
But I also need to be able to show the Traj column as different symbols based on the different values.
I also would like to be able to show the Type column as different colors.
How can I do this without going through one by one and changing them.
<colgroup><col span="3"><col span="2"></colgroup><tbody>
</tbody>
I need to make a simple chart of Date vs Time. So Column D vs column E.
But I also need to be able to show the Traj column as different symbols based on the different values.
I also would like to be able to show the Type column as different colors.
How can I do this without going through one by one and changing them.
Res | Type | Traj | Date | Time |
DA | Inj | ST | 5/27/2014 | 36 |
GA | Prod | NW | 6/12/2014 | 166.5417 |
DA | Inj | ST | 6/13/2014 | 25.854166 |
PA | Inj | ST | 6/23/2014 | 25.625 |
PA | Inj | ST | 6/27/2014 | 31.375 |
DA | Inj | ST | 6/29/2014 | 38.875 |
DA | Prod | ST | 6/30/2014 | 53.64583 |
GA | Prod | NW | 7/3/2014 | 79.4375 |
DA | Prod | ST | 7/5/2014 | 45.9 |
DA | Inj | ST | 7/26/2014 | 23.125 |
BA | Inj | ST | 7/28/2014 | 32.791666 |
BA | Inj | ST | 8/5/2014 | 40.27083 |
<colgroup><col span="3"><col span="2"></colgroup><tbody>
</tbody>