How to create a graph for Executive Out time

[Prasad L V A]

Hi, I am looking for help as how to create a graph to showcase the Executive Out time Target Vs Actuals (Day wise).

Attached sample file.

Help would be appreciated.

Best

 

[Hui]

Prasad

firstly, Welcome to the Chandoo.org Forums

How about this?


See attached file:

 

[Prasad L V A]

Prasad

firstly, Welcome to the Chandoo.org Forums

How about this?
View attachment 54382

See attached file:

It is just fantastic.

 

[Prasad L V A]

Hi Hui, It would be of great help if you can explain the logic in the formula & the chart. I have some other months data to be done.

 

[Prasad L V A]

Hi Hui, If you could help pl?

 

[Prasad L V A]

Hi Hui, You should be a busy man. Trying to grab your attention from last 10 days. It would be of great help if you can spare some time and help with logic of the formula & Chart. I have attached the sample file with all 4 months data. Really would appreciate your help...

 

[vletm]

Prasad L V A
You could do those like this ...
(Modify needed times to columns D, E, F & G as in samples
... some of those AM/PM looks... hmm?)

 

[Hui]

I have become snowed under and am sorry I won't get to this for a little bit
I am also working on a new Excel project which I want to publish soon.
It will blow your mind. It has blown my mind and I wrote it

The chart

There are 2 sets of stacked column charts
1 set for each vertical axis

The first series in each set is the start time and it is shaded with no fill, but if click below each Colored bar it will be highlighted

The second series, the colored column is the length of time

Click on each series and look at the source range for the series in the Formula Bar

Then follow the formula to see where they came from

 

[RedHotSun]

I guess the Graph should more like the one in attached file.

 

[vletm]

RedHotSun
... You used Hui's layout.
The graph would look as Your given data
(as I tried to write too in my sample).
ps. #9 Reply uses some formulas which don't work with me;
That's why, for me, there are many not valid values.

 

[Hui]

The two vertical axis in my original post have different vertical scales, so it is distorted a little