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
|
|||
|
|||
100% Stacked Bar chart, two bars, want percent as well as real value
I am attempting to chart the following:
Series 1 - Values over the prior 30 days Series 2 - Values over the prior 12 months I would like to show both data series as 100% bar charts, so users of the information can compare percentage of the last 30 days with percentage of the same piece of data over the last 12 months. So, for example the two data series might look like this: Series 1 20 25 45 65 Series 2 211 324 403 822 I want to display both the actual value, and the percentage of the total, for each series, in the labels. For some reason, showing percentage is not an option. Why is this? |
#2
|
|||
|
|||
100% Stacked Bar chart, two bars, want percent as well as real val
Although showing the percentage is not an option, you can easily do so by
creating two "dummy" series with data labels showing those percentages. To do so, create a series 3 and series 4 consisting of all zeros. Then create two seperate columns called "Series 3 Labels" and "Series 4 Labels". Calculate the percentages for series 3 and series 4 and add them to the "Series 3 Labels" and "Series 4 Labels" columns. Then use a tool such as John Walkenbach's Chart Tools to add those data labels to series 3 and 4. You can download John's tool at: http://www.j-walk.com/ss/excel/files/charttools.htm -- John Mansfield http://cellmatrix.net " wrote: I am attempting to chart the following: Series 1 - Values over the prior 30 days Series 2 - Values over the prior 12 months I would like to show both data series as 100% bar charts, so users of the information can compare percentage of the last 30 days with percentage of the same piece of data over the last 12 months. So, for example the two data series might look like this: Series 1 20 25 45 65 Series 2 211 324 403 822 I want to display both the actual value, and the percentage of the total, for each series, in the labels. For some reason, showing percentage is not an option. Why is this? |
Thread Tools | |
Display Modes | |
|
|