Time charts required for several activities (Work, Driving, Rest and Available)

[Cooldrinks]

Hi Everyone, I'm new to the Chandoo forum and I would real appreciate someone helping me out by trying to make what looks like to me, two very difficult charts. Heres what the two images of the charts I looking to make. I have not created them but are screen shots off of the web.


I have uploaded the file sample with the data extracted off of the internet.

I've literally dragged my mouse over the area on secure web page I require - copied and pasted into excel and tried messing around with charts to come out with nothing close, like the two images above.

I have posted this on another forum https://answers.microsoft.com/en-us...sure-how/57b4bf75-f31b-4b1a-9417-c95d750e55d3
but not had anyone reply with a solution.

Please, if possible, I'd like to re-create these two above charts with the data of sample file attached.

Thank you

David

Sample.xlsx

 

[Hui]

How is this for a start?


See attached file

 

[vletm]

Cooldrinks
There is [ Do It ]-button ...
press it ...
to get a sample.

 

[Hui]

Nice job Vletm!

 

[Cooldrinks]

Thank you Hui and vletm, you are both incredible. veltm you are a ninja in my eyes. I cannot get over the fact you did this.

 

[vletm]

Cooldrinks
Thanks
That was still a sample!
I made some modifications and now it would be a little better (?)
I used 'raw data' ... it's more useful.

Press those Buttons to select which You would like to see/hide.
There are still few things to check
... so this will continue

 

[vletm]

Cooldrinks
... there were some typos.
This would work better (if data has same layout as in this).

 

[Cooldrinks]

This is really amazing. I have other possibilities like adding "Harsh Breaking" or "Infringements" or "Speeding" see added sheet.
Sample_Graph_ver3.xlsb

 

[vletm]

Cooldrinks
... added those
and those cause a lot of changes!

 

[Cooldrinks]

Hi vletm

I've run the macro to create the two carts. There are a few things that would be helpful.

1. Current format: Need to unfreeze pane to allow Copy and Paste of raw data from website daily. There are 3 days of examples. This is what can happen and every day is possible to be different. See in sample below how I've changed format.

2. Extra data example 1 - 11:35, 14:14, Example 2 - 21:55 and example 3 to see another possibility.

3. Ability to deleted everything from A3:H. Currently all the symbols stay behind. See (Alert)

4. Group each chart generated by macro to create 2 pictures and to be able to move them to any position.

Sample_Graph_ver4.1.xlsb