Comination Chart with Custom Y-axis and Timeline?

tyfrown

New Member
Joined
Feb 8, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello all

My question is related to charting a set of data in a specific way that I can clarify as we go on, but the jist of it is included below,

I am in a bit of a pickle with a task I have to convert some MATLAB code into VBA. Usually my methodology to do this is to develop each chart individually and manually, then convert to VBA. I am at a loss as to where to start with one specific implementation of the data.

The type of chart I need to make contains a timeline. This timeline is tied to individual actors taking certain actions, in that the chart will be plotted as time vs actor/action. The actions that each individual can take are 4 discrete types, but they are tied to the timeline and actor in such a way that I cannot get it to work. I have attached a jpeg of how the chart will display, as my explanation is likely not clear. Some other lesser limitations that may be sticking points in the future, but i dont care about right now:

  • I only need the top "X" number of actors, say 20, that take the most amount of actions.
  • I am not sure what future data would like but it appears that each actor can only take one action type
  • larger datasets as time goes on
Things I have tried on my real time data:

  • Creating pivot table with date as the x and actor as y then creating a pivot chart.
  • Creating pivot table with date as the x and actor as y then creating a scatter chart various ways.
  • Filtering the dataset and creating a milestone chart.

I guess if this cannot be answered a fallback would be for guidance on what type of chart to research, an approach to display in multiple charts, the most I can get in a single chart (A fallback solution may be if we only filter by one action type, which I likewise cannot seem to get to work). I am unsure if this is a limitation on excel.

Sample_Data.xlsx
ABC
1Date/TimeActionActor
212/14/2020 04:50ACTION 1N618BR
312/14/2020 04:43ACTION 10D0C85
412/14/2020 04:36ACTION 10D0C85
512/14/2020 04:25ACTION 10D0C85
612/14/2020 04:16ACTION 1N618BR
712/14/2020 04:16ACTION 10D0C85
812/14/2020 03:51ACTION 10D0C85
912/14/2020 03:49ACTION 1N2353H
1012/14/2020 03:41ACTION 10D0C85
1112/14/2020 03:06ACTION 10D0C85
1212/14/2020 02:39ACTION 10D0C85
1312/14/2020 01:24ACTION 1N210DA
1412/14/2020 00:56ACTION 1N88F
1512/14/2020 00:46ACTION 1N88F
1612/14/2020 00:31ACTION 1N8142G
1712/13/2020 20:26ACTION 1N6813U
1812/13/2020 20:18ACTION 1N6813U
1912/13/2020 18:37ACTION 1N6654T
2012/13/2020 18:18ACTION 1N618BR
2112/13/2020 15:41ACTION 1N49WV
2212/13/2020 15:33ACTION 1N49WV
2312/13/2020 15:19ACTION 1N51464
2412/13/2020 15:09ACTION 1N8224F
2512/13/2020 15:02ACTION 1N6654T
2612/13/2020 14:47ACTION 1N7989P
2712/13/2020 14:32ACTION 1N7989P
2812/13/2020 06:34ACTION 1N618BR
2912/13/2020 04:22ACTION 106429D
3012/13/2020 03:26ACTION 1N2510Y
3112/13/2020 02:20ACTION 1N5283K
3212/13/2020 01:58ACTION 1N618RJ
3312/13/2020 01:25ACTION 1N275JP
3412/13/2020 00:38ACTION 106429D
3512/12/2020 22:42ACTION 1N7989P
3612/12/2020 22:37ACTION 2001210
3712/12/2020 22:33ACTION 1N7989P
3812/12/2020 21:54ACTION 10A80A4
3912/12/2020 21:50ACTION 10A80A4
4012/12/2020 20:07ACTION 1N39DE
4112/12/2020 19:51ACTION 1N39DE
4212/12/2020 18:33ACTION 2001210
4312/12/2020 18:24ACTION 2001210
4412/12/2020 18:16ACTION 2001210
4512/12/2020 18:10ACTION 2001210
4612/12/2020 13:54ACTION 1N275JP
4712/12/2020 13:51ACTION 1N748CB
4812/12/2020 13:43ACTION 1N748CB
4912/12/2020 13:19ACTION 1000416
5012/12/2020 10:29ACTION 1N275JP
5112/12/2020 08:18ACTION 1N13TA
5212/12/2020 08:12ACTION 1N13TA
5312/12/2020 04:42ACTION 1N399AN
5412/12/2020 03:54ACTION 1N3135W
5512/12/2020 02:41ACTION 1N8142G
5612/12/2020 02:06ACTION 2001210
5712/12/2020 01:37ACTION 1N275JP
5812/12/2020 01:29ACTION 1N275JP
5912/12/2020 01:27ACTION 10D0C85
6012/12/2020 01:24ACTION 10D0C85
6112/11/2020 23:11ACTION 1N12345
6212/11/2020 21:34ACTION 1N18987
6312/11/2020 21:33ACTION 1N275JP
6412/11/2020 21:31ACTION 1N748CB
6512/11/2020 21:28ACTION 1N748CB
6612/11/2020 21:20ACTION 1N748CB
6712/11/2020 21:17ACTION 1N618RJ
6812/11/2020 21:16ACTION 1N275JP
6912/11/2020 21:16ACTION 1N748CB
7012/11/2020 21:12ACTION 1N275JP
7112/11/2020 21:11ACTION 10D0C85
7212/11/2020 21:09ACTION 10D0C85
7312/11/2020 21:09ACTION 1N748CB
7412/11/2020 21:06ACTION 10D0C85
7512/11/2020 20:25ACTION 1N748CB
7612/11/2020 20:13ACTION 1N6060Z
7712/11/2020 20:12ACTION 1N275JP
7812/11/2020 19:36ACTION 1N748CB
7912/11/2020 19:30ACTION 1N748CB
8012/11/2020 19:23ACTION 1N275JP
8112/11/2020 19:22ACTION 1N8359L
8212/11/2020 19:18ACTION 1N748CB
8312/11/2020 18:54ACTION 1N737CU
8412/11/2020 18:52ACTION 1N6654T
8512/11/2020 18:50ACTION 1N275JP
8612/11/2020 18:50ACTION 1N737C
8712/11/2020 18:18ACTION 1N175SW
8812/11/2020 17:55ACTION 1N120KF
8912/11/2020 17:52ACTION 1N7054V
9012/11/2020 17:49ACTION 1N189J
9112/11/2020 17:44ACTION 1N189J
9212/11/2020 17:23ACTION 1N421AR
9312/11/2020 16:57ACTION 1N28012
9412/11/2020 16:46ACTION 1N41538
9512/11/2020 16:40ACTION 1N41538
9612/11/2020 16:30ACTION 1N41538
9712/11/2020 16:28ACTION 1N41538
9812/11/2020 16:24ACTION 1N275JP
9912/11/2020 16:04ACTION 1N51464
10012/11/2020 15:33ACTION 1N8142G
10112/11/2020 14:34ACTION 1N13TA
10212/11/2020 14:30ACTION 1N13TA
10312/11/2020 14:16ACTION 1N7054V
10412/11/2020 14:04ACTION 1N6813U
10512/11/2020 12:33ACTION 1N88F
10612/11/2020 12:22ACTION 1N88F
10712/11/2020 11:34ACTION 271BD99
10812/11/2020 10:50ACTION 1000525
10912/11/2020 06:28ACTION 1N73402
11012/11/2020 06:07ACTION 1N2540Q
11112/11/2020 03:45ACTION 1N6316X
11212/11/2020 00:46ACTION 1N219B
11312/11/2020 00:07ACTION 1N381S
11412/10/2020 23:31ACTION 1N200DV
11512/10/2020 22:59ACTION 1N7871T
11612/10/2020 22:48ACTION 1N7871T
11712/10/2020 21:33ACTION 1C02020
11812/10/2020 18:33ACTION 1N501ME
11912/10/2020 18:03ACTION 1N6570H
12012/10/2020 17:30ACTION 1N9812L
12112/10/2020 17:27ACTION 1N8359L
12212/10/2020 17:24ACTION 1N8359L
12312/10/2020 17:20ACTION 1N8359L
12412/10/2020 17:05ACTION 1N270KW
12512/10/2020 16:47ACTION 1N1498M
12612/10/2020 16:42ACTION 1N1498M
12712/10/2020 16:23ACTION 271BD99
12812/10/2020 16:13ACTION 1N175SW
12912/10/2020 16:07ACTION 1N175SW
13012/10/2020 16:02ACTION 1N175SW
13112/10/2020 14:37ACTION 1N7360W
13212/10/2020 14:36ACTION 1N130G
13312/10/2020 14:35ACTION 1N130G
13412/10/2020 14:32ACTION 1N130G
13512/10/2020 13:43ACTION 1E4827D
13612/10/2020 13:38ACTION 1N6813U
13712/10/2020 13:16ACTION 1N914ZZ
13812/10/2020 13:13ACTION 1N914ZZ
13912/10/2020 12:09ACTION 1N48LC
14012/10/2020 11:54ACTION 2851142
14112/10/2020 11:42ACTION 1N2354R
14212/10/2020 10:52ACTION 1E482B3
14312/10/2020 09:40ACTION 1N4679G
14412/10/2020 05:10ACTION 1N2238K
14512/10/2020 04:35ACTION 10D0C85
14612/10/2020 04:33ACTION 10D0C85
14712/10/2020 04:05ACTION 1N381S
14812/10/2020 03:26ACTION 10D0C85
14912/10/2020 02:25ACTION 1N1498M
15012/10/2020 01:01ACTION 1N454LF
15112/09/2020 23:38ACTION 1N120KF
15212/09/2020 22:15ACTION 1E4827D
15312/09/2020 21:29ACTION 1N597SF
15412/09/2020 20:52ACTION 1N361PH
15512/09/2020 20:31ACTION 1N5745G
15612/09/2020 20:26ACTION 1N5745G
15712/09/2020 20:01ACTION 1N189J
15812/09/2020 19:56ACTION 1N501ME
15912/09/2020 17:33ACTION 1N1303H
16012/09/2020 16:33ACTION 1N2306Y
16112/09/2020 16:10ACTION 1N5906A
16212/09/2020 15:44ACTION 1N76975
16312/09/2020 15:08ACTION 1E4827D
16412/09/2020 15:07ACTION 1N811JT
16512/09/2020 14:59ACTION 1N12345
16612/09/2020 14:25ACTION 1N142EM
16712/09/2020 13:46ACTION 1N584YK
16812/09/2020 13:18ACTION 1N914ZZ
16912/09/2020 12:15ACTION 145209E
17012/09/2020 11:51ACTION 1E482B3
17112/09/2020 08:31ACTION 1N218GA
17212/09/2020 08:27ACTION 1N217GA
17312/09/2020 04:39ACTION 1N9198H
17412/09/2020 02:56ACTION 1N811JT
17512/08/2020 20:26ACTION 1000525
17612/08/2020 19:54ACTION 1N5893L
17712/08/2020 19:50ACTION 1N5893L
17812/08/2020 19:47ACTION 1N5893L
17912/08/2020 19:03ACTION 2C054A3
18012/08/2020 17:06ACTION 1N241AR
18112/08/2020 16:42ACTION 1N2845L
18212/08/2020 16:39ACTION 1N2144J
18312/08/2020 16:05ACTION 1N120KF
18412/08/2020 15:48ACTION 1N7216W
18512/08/2020 15:46ACTION 1N275JP
18612/08/2020 15:46ACTION 1N7216W
18712/08/2020 15:41ACTION 1N7216W
18812/08/2020 14:43ACTION 1N2027P
18912/08/2020 14:03ACTION 1E4819A
19012/08/2020 13:07ACTION 1E4819A
19112/08/2020 13:02ACTION 1E4819A
19212/08/2020 12:37ACTION 145209E
19312/08/2020 11:31ACTION 1N78GK
19412/08/2020 11:29ACTION 1N78GK
19512/08/2020 11:25ACTION 1N78GK
19612/08/2020 10:26ACTION 1N12795
19712/08/2020 09:28ACTION 18404F4
19812/08/2020 05:28ACTION 1N2540Q
19912/08/2020 05:07ACTION 1C04F87
20012/08/2020 03:35ACTION 1N3135W
20112/08/2020 03:11ACTION 1N914ZZ
20212/07/2020 23:47ACTION 1E4819A
20312/07/2020 23:34ACTION 1E4819A
20412/07/2020 21:29ACTION 1N8302T
20512/07/2020 20:22ACTION 1N12795
20612/07/2020 20:12ACTION 1N12795
20712/07/2020 19:29ACTION 1N8306N
20812/07/2020 19:16ACTION 1N722DJ
20912/07/2020 19:15ACTION 1N453LC
21012/07/2020 18:56ACTION 1N778MA
21112/07/2020 17:55ACTION 1N11KA
21212/07/2020 17:26ACTION 1N914ZZ
21312/07/2020 17:15ACTION 1N914ZZ
21412/07/2020 17:11ACTION 1N914ZZ
21512/07/2020 17:09ACTION 1E4819A
21612/07/2020 16:15ACTION 1E4819A
21712/07/2020 15:37ACTION 1N8833Y
21812/07/2020 15:32ACTION 1000525
21912/07/2020 15:28ACTION 1000525
22012/07/2020 14:15ACTION 1N275JP
22112/07/2020 13:19ACTION 1N8302T
22212/07/2020 08:10ACTION 18404F4
22312/07/2020 05:29ACTION 1N9653Y
22412/07/2020 03:35ACTION 18404F4
22512/07/2020 03:06ACTION 1N12795
22612/07/2020 02:46ACTION 1N5893L
22712/07/2020 02:33ACTION 1N6125J
22812/07/2020 01:23ACTION 1N914ZZ
22912/07/2020 00:29ACTION 1N20562
23012/06/2020 22:40ACTION 1N176G
23112/06/2020 19:33ACTION 1N7564T
23212/06/2020 19:29ACTION 1N7564T
23312/06/2020 19:09ACTION 1N406DE
23412/06/2020 17:45ACTION 1N9102L
23512/06/2020 17:42ACTION 1N9543H
23612/06/2020 16:46ACTION 1N47SE
23712/06/2020 16:21ACTION 1N2047L
23812/06/2020 16:20ACTION 1N2047L
23912/06/2020 15:37ACTION 1N8302T
24012/06/2020 15:16ACTION 1N191DP
24112/06/2020 14:04ACTION 1N821XG
24212/06/2020 13:53ACTION 1N39DE
24312/06/2020 13:50ACTION 10D09D6
24412/06/2020 13:42ACTION 1N346CS
24512/06/2020 13:33ACTION 1N518PA
24612/06/2020 12:59ACTION 1N3982D
24712/06/2020 12:23ACTION 1000525
24812/06/2020 10:55ACTION 108007B
24912/06/2020 10:44ACTION 108007B
25012/06/2020 04:03ACTION 1N240AT
25112/06/2020 03:57ACTION 1N5150D
25212/06/2020 01:27ACTION 1N958RW
25312/06/2020 01:22ACTION 10D09D6
25412/06/2020 01:14ACTION 1N958RW
25512/06/2020 01:11ACTION 1N333JG
25612/06/2020 01:08ACTION 1N8621Y
25712/05/2020 23:31ACTION 1E032CB
25812/05/2020 22:09ACTION 1N2047L
25912/05/2020 20:45ACTION 1N518PA
26012/05/2020 20:38ACTION 1N518PA
26112/05/2020 20:17ACTION 1N48LC
26212/05/2020 20:15ACTION 1N48LC
26312/05/2020 19:30ACTION 1N96371
26412/05/2020 18:49ACTION 2001210
26512/05/2020 18:38ACTION 108007B
26612/05/2020 18:35ACTION 108007B
26712/05/2020 18:01ACTION 1N7503W
26812/05/2020 17:57ACTION 1N48LC
26912/05/2020 17:23ACTION 1N8786S
27012/05/2020 17:18ACTION 1N8786S
27112/05/2020 15:05ACTION 1N29933
27212/05/2020 14:38ACTION 1N685SP
27312/05/2020 14:18ACTION 1000525
27412/05/2020 14:13ACTION 1N519PB
27512/05/2020 13:33ACTION 1N723M
27612/05/2020 03:28ACTION 1N17621
27712/05/2020 03:11ACTION 1N8318H
27812/05/2020 02:33ACTION 1N7027F
27912/05/2020 02:30ACTION 1N7027F
28012/05/2020 02:15ACTION 1N9543H
28112/05/2020 01:48ACTION 100B190
28212/05/2020 01:40ACTION 1N240AT
28312/05/2020 01:35ACTION 1N149CG
28412/05/2020 01:34ACTION 1N240AT
28512/05/2020 00:30ACTION 1N92567
28612/05/2020 00:22ACTION 1N92567
28712/04/2020 23:25ACTION 1N4864D
28812/04/2020 23:15ACTION 2001210
28912/04/2020 22:23ACTION 1N2429Y
29012/04/2020 21:15ACTION 1N3347A
29112/04/2020 19:27ACTION 1N123FR
29212/04/2020 19:07ACTION 1N882KC
29312/04/2020 19:05ACTION 1N29933
29412/04/2020 18:51ACTION 1N197RH
29512/04/2020 17:09ACTION 1N4866K
29612/04/2020 17:06ACTION 1N4866K
29712/04/2020 16:15ACTION 1N6294D
29812/04/2020 14:19ACTION 1N4527J
29912/04/2020 14:08ACTION 1N311CH
30012/04/2020 13:57ACTION 1N311CH
30112/04/2020 09:49ACTION 1N2395Z
30212/04/2020 05:30ACTION 1N182BN
30312/04/2020 02:51ACTION 1N7593Y
30412/04/2020 01:59ACTION 1N7995L
30512/04/2020 01:16ACTION 1N48LC
30612/04/2020 01:15ACTION 1N74817
30712/04/2020 01:09ACTION 1E48711
30812/04/2020 00:39ACTION 1N7995L
Sheet1
 

Attachments

  • Sample_picture.jpg
    Sample_picture.jpg
    25.4 KB · Views: 1

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,127,505
Messages
5,625,199
Members
416,080
Latest member
blemon

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
Top