Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
If I have data for varying times in a column chart, how do I space | Charts and Charting in Excel | |||
Column Chart to Line Chart | New Users to Excel | |||
Making Special "Stacked Column" Chart | Charts and Charting in Excel | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |