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
102 64 166 41
104 62 166 42
103 69 172 43
102 61 163 36
100 56 156 30
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, calculated as follows:
Column B data: B/C %
Column D data: D/C %
Regards
Hans Knudsen
series?
Here is the data:
A B C =A+B D
102 64 166 41
104 62 166 42
103 69 172 43
102 61 163 36
100 56 156 30
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, calculated as follows:
Column B data: B/C %
Column D data: D/C %
Regards
Hans Knudsen