Charting question

brandon20

Board Regular
Joined
Feb 12, 2014
Messages
203
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.





ResTypeTrajDateTime
DAInjST5/27/201436
GAProdNW6/12/2014166.5417
DAInjST6/13/201425.854166
PAInjST6/23/201425.625
PAInjST6/27/201431.375
DAInjST6/29/201438.875
DAProdST6/30/201453.64583
GAProdNW7/3/201479.4375
DAProdST7/5/201445.9
DAInjST7/26/201423.125
BAInjST7/28/201432.791666
BAInjST8/5/201440.27083

<colgroup><col span="3"><col span="2"></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Sort you data like this:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Res</td><td style=";">Type</td><td style=";">Traj</td><td style=";">Date</td><td style=";">Time</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">GA</td><td style=";">Prod</td><td style=";">NW</td><td style="text-align: right;;">12/06/2014</td><td style="text-align: right;;">166.5417</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">GA</td><td style=";">Prod</td><td style=";">NW</td><td style="text-align: right;;">03/07/2014</td><td style="text-align: right;;">79.4375</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">DA</td><td style=";">Inj</td><td style=";">ST</td><td style="text-align: right;;">27/05/2014</td><td style="text-align: right;;">36</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">DA</td><td style=";">Inj</td><td style=";">ST</td><td style="text-align: right;;">13/06/2014</td><td style="text-align: right;;">25.854166</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">PA</td><td style=";">Inj</td><td style=";">ST</td><td style="text-align: right;;">23/06/2014</td><td style="text-align: right;;">25.625</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">PA</td><td style=";">Inj</td><td style=";">ST</td><td style="text-align: right;;">27/06/2014</td><td style="text-align: right;;">31.375</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">DA</td><td style=";">Inj</td><td style=";">ST</td><td style="text-align: right;;">29/06/2014</td><td style="text-align: right;;">38.875</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">DA</td><td style=";">Inj</td><td style=";">ST</td><td style="text-align: right;;">26/07/2014</td><td style="text-align: right;;">23.125</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">BA</td><td style=";">Inj</td><td style=";">ST</td><td style="text-align: right;;">28/07/2014</td><td style="text-align: right;;">32.791666</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style=";">BA</td><td style=";">Inj</td><td style=";">ST</td><td style="text-align: right;;">05/08/2014</td><td style="text-align: right;;">40.27083</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style=";">DA</td><td style=";">Prod</td><td style=";">ST</td><td style="text-align: right;;">30/06/2014</td><td style="text-align: right;;">53.64583</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style=";">DA</td><td style=";">Prod</td><td style=";">ST</td><td style="text-align: right;;">05/07/2014</td><td style="text-align: right;;">45.9</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br />

Then have 3 series on your chart, rows 2:3, 4:11 and 12:13.
 

brandon20

Board Regular
Joined
Feb 12, 2014
Messages
203
Thanks,

I would like to find a work around so I dont have to select multiple series on my chart.
There are far to many series in my real data and I dont want to have to keep going back and forth to the chart as it is live and changing all the time.

thanks though.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,156
Messages
5,442,693
Members
405,192
Latest member
Jesse McCarron

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top