If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Charting: Displaying cumulative totals at top of stacked columns
Hi,
I'm having some trouble displaying the cumulative total at the TOP of each of my two stacked columns. Right now, only one of the columns have the total value on top while the other one has it in the middle. To be more specific, this is the exact scenario: I'm trying to graph the revenue data of 2005 and expected of 2009. So there are two stacked columns in this graph. And these columns can be stacked by different product revenues. I want to show the cumulative total of each stacked column, but the shorter 2005 column displays the total value half-way up the column instead of at the top of the column. I used the steps recommended by the following website: http://www.andypope.info/charts/StackColTotal.htm but I still can't solve this problem. Any help would be much appreciated! And I have an example file if that would make the question clearer. Thanks in advance, Jean |
#2
|
|||
|
|||
Charting: Displaying cumulative totals at top of stacked columns
Hi Jean,
If you want to email me the example file I will take a look see. Cheers Andy Jean wrote: Hi, I'm having some trouble displaying the cumulative total at the TOP of each of my two stacked columns. Right now, only one of the columns have the total value on top while the other one has it in the middle. To be more specific, this is the exact scenario: I'm trying to graph the revenue data of 2005 and expected of 2009. So there are two stacked columns in this graph. And these columns can be stacked by different product revenues. I want to show the cumulative total of each stacked column, but the shorter 2005 column displays the total value half-way up the column instead of at the top of the column. I used the steps recommended by the following website: http://www.andypope.info/charts/StackColTotal.htm but I still can't solve this problem. Any help would be much appreciated! And I have an example file if that would make the question clearer. Thanks in advance, Jean -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Graph Report Not Displaying All Columns | CJ | Setting Up & Running Reports | 2 | August 5th, 2005 02:27 PM |
Multiple Stacked Columns (need secondary y-axis values too) | Ross M | Charts and Charting | 1 | January 20th, 2004 04:55 PM |
Clustered and stacked columns at the same time | Patrick | Charts and Charting | 4 | November 19th, 2003 05:36 PM |
Combo Chart of stacked columns and line | Antje Crawford | Charts and Charting | 1 | November 15th, 2003 12:23 AM |
Stacked Columns with multiple categories | Erik | Charts and Charting | 2 | October 14th, 2003 05:26 PM |