Stack chart sum values

[julesh1975]

Hi

Could you tell me if it's possible to sum values to create each stack in a stack chart please?

The data I have is split into monthly values and I need to produce a stack chart that shows the quarterly value per series

Sheet1

*

A

B

C

D

E

F

G

H

I

J

K

L

M

1

*

Q1

Q2

Q3

Q4

2

a

1

1

1

2

1

0

1

1

2

1

1

2

3

b

0

1

2

2

2

2

1

0

1

1

0

0

4

c

1

2

1

1

0

0

1

2

1

0

1

0

5

d

0

1

1

1

0

1

1

0

0

0

0

0

6

*

*

*

*

*

*

*

*

*

*

*

*

*

7

*

*

*

*

*

*

*

*

*

*

*

*

*

8

*

*

*

*

*

*

*

*

*

*

*

*

*

9

*

*

*

*

*

*

*

*

*

*

*

*

*

10

*

*

*

*

*

*

*

*

*

*

*

*

*

11

*

12

d

d

*

*

*

*

*

*

*

*

*

12

*

*

*

*

d

*

*

*

*

*

*

*

*

13

*

*

c

c

c

*

*

*

*

*

*

*

*

14

*

*

*

b

*

*

*

*

*

*

*

*

*

15

*

*

*

*

*

*

*

*

*

*

*

*

*

16

*

*

*

*

*

*

*

*

*

*

*

*

*

17

*

*

b

*

b

c

*

*

*

*

*

*

*

18

*

*

*

*

*

b

*

*

*

*

*

*

*

19

*

*

*

*

a

a

*

*

*

*

*

*

*

20

*

*

a

a

*

*

*

*

*

*

*

*

*

21

*

*

*

*

*

*

*

*

*

*

*

*

*

22

*

*

*

*

*

*

*

*

*

*

*

*

*

23

*

*

Q1

Q2

Q3

Q4

*

*

*

*

*

*

*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Not sure if the description explains this very well but hopefully the diagram shows what I'm trying to achieve (I've colour coded quarter 1 as an example).

Thanks in advance