H
Hans Knudsen
How do I create a column chart that (as data labels) shows the actual numbers for one of the series and percentages for two other
series. Here is the data:
A
B
C=A+B
D
E=C+D
B/C %
D/C %
102
64
166
41
207
38,6%
24,7%
104
62
166
42
208
37,3%
25,3%
103
69
172
43
215
40,1%
25,0%
102
61
163
36
199
37,4%
22,1%
100
56
156
30
186
35,9%
19,2%
The chart must show the numbers in column A, B and D where the data labels for column A data should be 102, 104 etc whereas for
column B and D it should be percentages as shown in the two rightmost columns.
Regards
Hans Knudsen
series. Here is the data:
A
B
C=A+B
D
E=C+D
B/C %
D/C %
102
64
166
41
207
38,6%
24,7%
104
62
166
42
208
37,3%
25,3%
103
69
172
43
215
40,1%
25,0%
102
61
163
36
199
37,4%
22,1%
100
56
156
30
186
35,9%
19,2%
The chart must show the numbers in column A, B and D where the data labels for column A data should be 102, 104 etc whereas for
column B and D it should be percentages as shown in the two rightmost columns.
Regards
Hans Knudsen