Thread: Column Chart
View Single Post
  #2   Report Post  
Hans Knudsen
 
Posts: n/a
Default

My apologies for this complete mess. I will try again later.
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
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