|
Stacked Chart help needed
Ok, I am trying to make a stacked chart that starts at points other
than zero but can still have the data label show the actual point. Even more complicated is I would like to have a label that is based on a point somewhere in the range of the stack. Here is a sample of what I am looking for: The start point mid point and end point I want to display the stacked chart a 10 15 20 Currently I just use 10,5,5 as my data for the chart and then just hide the first column in the stack (0-10). I would like to be able have the very bottom stack start at 10 so that there are just two stacks in this data plot, 10-15 and 15-20. Then I sould like to be able to plot on the stacked chart a seperate data point that is somewhere in the range - say 17.5. This data point will change so really this chart is kind of a slider chart. I have been messing with this one for a while now and am just stumped. Any help is greatly appreciated. Will |
Stacked Chart help needed
I'm not clear on what you want to do, but you might check out Jon Peltier's
site to see what he has on Stacked Charts. http://www.peltiertech.com/Excel/Charts/index.html wrote in message ups.com... Ok, I am trying to make a stacked chart that starts at points other than zero but can still have the data label show the actual point. Even more complicated is I would like to have a label that is based on a point somewhere in the range of the stack. Here is a sample of what I am looking for: The start point mid point and end point I want to display the stacked chart a 10 15 20 Currently I just use 10,5,5 as my data for the chart and then just hide the first column in the stack (0-10). I would like to be able have the very bottom stack start at 10 so that there are just two stacks in this data plot, 10-15 and 15-20. Then I sould like to be able to plot on the stacked chart a seperate data point that is somewhere in the range - say 17.5. This data point will change so really this chart is kind of a slider chart. I have been messing with this one for a while now and am just stumped. Any help is greatly appreciated. Will |
Stacked Chart help needed
Sorry for the delayed response. I am just trying to make a slider
chart that automatically updates when values change. It is to compare the performance of several companies on several metrics. For example: There are 3 categories (ROA, ROE, P/E Multiple) and I want to compare the value of Company A to its peers (Companies B through E) for each metric. So lets say the following is the data for ROA which would be the first stacked bar. ROA Company A = 1.00 Company B = 1.25 Company C = 1.50 Company D = 1.75 Company E = 0.75 I want the bar to start at 0.75 (and display 0.75) and go up to 1.75 (and display 1.75). I would like to have some type of slider that moves up or down the stacked bar chart according to its value. In this case it would be at 1.00. I would like this to be dynamic so if the numbers change the stacked chart changes as well. I have been unsuccessful thus far at figuring out how to do this. Any help is greatly appreciated. |
Stacked Chart help needed
Will -
Here's how I constructed a sample: I arranged the data in A1:B8 as follows: ROA Min 0.75 Max - Min 1 Company A 1 Company B 1.25 Company C 1.5 Company D 1.75 Company E 0.75 You can use columns C and D for ROE and P/E. I didn't, because you hadn't included the data. The formula in B2 is simply =MIN(B4:B8) and in B3 is =MAX(B4:B8)-MIN(B4:B8). I selected the whole area, and created a stacked column chart, with series in rows. This created all series as stacked columns, but it's easy to switch the ones you want. Select the Company A series, and on the Chart menu, use Chart Type to change this series to a Line type. Select the Company B series, and repeat this action, most simply by pressing the F4 key. This plots all of the companies, and you'd only asked for Company A. If you don't want all the series, delete the ones you don't want, or start by selecting just A1:B4 before creating the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Sorry for the delayed response. I am just trying to make a slider chart that automatically updates when values change. It is to compare the performance of several companies on several metrics. For example: There are 3 categories (ROA, ROE, P/E Multiple) and I want to compare the value of Company A to its peers (Companies B through E) for each metric. So lets say the following is the data for ROA which would be the first stacked bar. ROA Company A = 1.00 Company B = 1.25 Company C = 1.50 Company D = 1.75 Company E = 0.75 I want the bar to start at 0.75 (and display 0.75) and go up to 1.75 (and display 1.75). I would like to have some type of slider that moves up or down the stacked bar chart according to its value. In this case it would be at 1.00. I would like this to be dynamic so if the numbers change the stacked chart changes as well. I have been unsuccessful thus far at figuring out how to do this. Any help is greatly appreciated. |
Stacked Chart help needed
That worked. Thank you so much for the help.
Will |
| All times are GMT +1. The time now is 03:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com