Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I add Cumulative values to Stacked Bar chart?
I have a stacked bar chart in which i want to show the value label of each
section and show the cumlative value. So if there is section A,B,C and A= 1, B= 2, C = 3 I want each section to have those labels but i also want labels that say 1, 3, 6 for the cumulative values. Is there anyway to do this? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I add Cumulative values to Stacked Bar chart?
Hi,
Use a helper column to build the required text for each data label. So if you data values are in B2:B4 then put the following in C2 and copy down. ="Value = " & B2 & CHAR(10) &"CumValue=" & SUM($B$2:B2) Then use either of these free addin to make the linking of cells and data labels easier. Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com Cheers Andy aspelker wrote: I have a stacked bar chart in which i want to show the value label of each section and show the cumlative value. So if there is section A,B,C and A= 1, B= 2, C = 3 I want each section to have those labels but i also want labels that say 1, 3, 6 for the cumulative values. Is there anyway to do this? Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indexing Values to Same Starting Point for Relative Return Chart | Charts and Charting in Excel | |||
Stacked chart with line | Charts and Charting in Excel | |||
how do I create a stacked bar chart in excel | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel |