Stacked Chart help needed

  • Thread starter Thread starter willjohnson33
  • Start date Start date
W

willjohnson33

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 are:
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
 
Any hints as to why you're doing this? It might help someone figure out
a workable suggestion.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
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.
 
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/
_______
 
Back
Top