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>
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort you data like this:


Excel 2010
ABCDE
1ResTypeTrajDateTime
2GAProdNW12/06/2014166.5417
3GAProdNW03/07/201479.4375
4DAInjST27/05/201436
5DAInjST13/06/201425.854166
6PAInjST23/06/201425.625
7PAInjST27/06/201431.375
8DAInjST29/06/201438.875
9DAInjST26/07/201423.125
10BAInjST28/07/201432.791666
11BAInjST05/08/201440.27083
12DAProdST30/06/201453.64583
13DAProdST05/07/201445.9
Sheet1


Then have 3 series on your chart, rows 2:3, 4:11 and 12:13.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top