Stacked Column Charting
 

Has anyone tried the following?

From the data set below, I would like to have the data to the right of the
Hrs. avail data be a stacked bar for each day. Along with this the Hrs. avail
data would be a bar next to the remaing row of data.

I tried placing the Hrs. avail on its own axis but that did not seem to work.

In short I want to show the number of hours availabe in a day and actual
hours used by the verious other data.

Regards,

Hal

Day Hrs. avail EM's PM's Cal's Projects Other Idle
1 14 4 2.5 2 4 0 1.5
2 14 5 1 1 3 0 4
3 14 0 2 2 6 0 4
4 7 2 0 0 3 0 2
5 14 2 0 0 10 0 2
6 14 2 0 0 12 0 0
7 14 2 0 0 8.5 0 3.5
8 0 0 0 0 0 0 0
9 14 4 0 0 8 0 2
10 14 4 0 0 8 0 2
11 14 4 0 0 8 0 2
12 14 4 0 0 8 0 2
13 14 2 0 0 12 0 0
14 14 3 0 0 7 0 4
15 14 3 0 0 7 0 4
16 14 3 0 0 1 7 3
17 14 3 0 0 8 0 3
18 14 3 0 0 8 0 3
19 14 2 0 0 7 0 5
20 14 2 0 0 7 0 5
21 14 3 0 0 7.5 0 3.5
22 14 3 0 0 7.5 0 3.5
23 14 3 0 0 7.5 0 3.5
24 14 3 0 0 7.5 0 3.5
25 14 3 0 0 7.5 0 3.5
26 14 4 0 0 6 0 4
27 14 2 0 0 8 0 4
28 14 4 0 0 7 0 3
29 14 4 0 0 7 0 3
30 14 4 0 0 7 0 3

Stacked Column Charting
 

Treat is as a clustered-stacked column chart, with a stack of one column
next to a stack of many:

http://peltiertech.com/WordPress/200...column-charts/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Hal" wrote in message
...
Has anyone tried the following?

From the data set below, I would like to have the data to the right of
the
Hrs. avail data be a stacked bar for each day. Along with this the Hrs.
avail
data would be a bar next to the remaing row of data.

I tried placing the Hrs. avail on its own axis but that did not seem to
work.

In short I want to show the number of hours availabe in a day and actual
hours used by the verious other data.

Regards,

Hal

Day Hrs. avail EM's PM's Cal's Projects Other Idle
1 14 4 2.5 2 4 0 1.5
2 14 5 1 1 3 0 4
3 14 0 2 2 6 0 4
4 7 2 0 0 3 0 2
5 14 2 0 0 10 0 2
6 14 2 0 0 12 0 0
7 14 2 0 0 8.5 0 3.5
8 0 0 0 0 0 0 0
9 14 4 0 0 8 0 2
10 14 4 0 0 8 0 2
11 14 4 0 0 8 0 2
12 14 4 0 0 8 0 2
13 14 2 0 0 12 0 0
14 14 3 0 0 7 0 4
15 14 3 0 0 7 0 4
16 14 3 0 0 1 7 3
17 14 3 0 0 8 0 3
18 14 3 0 0 8 0 3
19 14 2 0 0 7 0 5
20 14 2 0 0 7 0 5
21 14 3 0 0 7.5 0 3.5
22 14 3 0 0 7.5 0 3.5
23 14 3 0 0 7.5 0 3.5
24 14 3 0 0 7.5 0 3.5
25 14 3 0 0 7.5 0 3.5
26 14 4 0 0 6 0 4
27 14 2 0 0 8 0 4
28 14 4 0 0 7 0 3
29 14 4 0 0 7 0 3
30 14 4 0 0 7 0 3

Stacked Column Charting
 

Thanks for info Jon,

Here it is the 2nd of Aug and I'm just getting around to checking for replies.

I'll give this a try at work next week.

Best Regards,

Hal

"Jon Peltier" wrote:

Treat is as a clustered-stacked column chart, with a stack of one column
next to a stack of many:

http://peltiertech.com/WordPress/200...column-charts/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Hal" wrote in message
...
Has anyone tried the following?

From the data set below, I would like to have the data to the right of
the
Hrs. avail data be a stacked bar for each day. Along with this the Hrs.
avail
data would be a bar next to the remaing row of data.

I tried placing the Hrs. avail on its own axis but that did not seem to
work.

In short I want to show the number of hours availabe in a day and actual
hours used by the verious other data.

Regards,

Hal

Day Hrs. avail EM's PM's Cal's Projects Other Idle
1 14 4 2.5 2 4 0 1.5
2 14 5 1 1 3 0 4
3 14 0 2 2 6 0 4
4 7 2 0 0 3 0 2
5 14 2 0 0 10 0 2
6 14 2 0 0 12 0 0
7 14 2 0 0 8.5 0 3.5
8 0 0 0 0 0 0 0
9 14 4 0 0 8 0 2
10 14 4 0 0 8 0 2
11 14 4 0 0 8 0 2
12 14 4 0 0 8 0 2
13 14 2 0 0 12 0 0
14 14 3 0 0 7 0 4
15 14 3 0 0 7 0 4
16 14 3 0 0 1 7 3
17 14 3 0 0 8 0 3
18 14 3 0 0 8 0 3
19 14 2 0 0 7 0 5
20 14 2 0 0 7 0 5
21 14 3 0 0 7.5 0 3.5
22 14 3 0 0 7.5 0 3.5
23 14 3 0 0 7.5 0 3.5
24 14 3 0 0 7.5 0 3.5
25 14 3 0 0 7.5 0 3.5
26 14 4 0 0 6 0 4
27 14 2 0 0 8 0 4
28 14 4 0 0 7 0 3
29 14 4 0 0 7 0 3
30 14 4 0 0 7 0 3