Column Chart
 

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

Please forget about it. I suddenly remembered Rob Bovey's fine tool which I had already.
Hans



"Hans Knudsen" skrev i en meddelelse ...
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