A Jedi
Board Regular
- Joined
- Mar 23, 2004
- Messages
- 86
I have a data set that looks like this
a 1 2 3 4 5 6 7
b 1 2 3 4 5 6 7
c 1 2 3 4 5 6 7
a1 1 2 3 4 5 6 7
b1 1 2 3 4 5 6 7
c1 1 2 3 4 5 6 7
I want to have a chart with a stacked column for a, b, c across the columns and then a line graph for the sum of a1, b1, c1 across the columns.
I can get the stacked column chart for a,b,c but how do I make a formula for a1,b1,c1 across the columns?
a 1 2 3 4 5 6 7
b 1 2 3 4 5 6 7
c 1 2 3 4 5 6 7
a1 1 2 3 4 5 6 7
b1 1 2 3 4 5 6 7
c1 1 2 3 4 5 6 7
I want to have a chart with a stacked column for a, b, c across the columns and then a line graph for the sum of a1, b1, c1 across the columns.
I can get the stacked column chart for a,b,c but how do I make a formula for a1,b1,c1 across the columns?