Prev Previous Post   Next Post Next
  #1   Report Post  
Hans Knudsen
 
Posts: n/a
Default 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
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to group similar column titles together???? vrk1 Excel Discussion (Misc queries) 2 April 30th 05 12:17 AM
If I have data for varying times in a column chart, how do I space tc1967uk Charts and Charting in Excel 1 February 22nd 05 06:03 PM
Column Chart to Line Chart enquirer New Users to Excel 1 January 17th 05 09:55 PM
Making Special "Stacked Column" Chart Chaplain Doug Charts and Charting in Excel 3 December 10th 04 04:31 PM
How can I sort an entire spreadsheet from a list prod sorter Excel Worksheet Functions 4 November 17th 04 03:43 AM


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"