Hello everyone,

Here is a problem that has been puzzling me. I am looking to create a
column or bar chart that moves in two directions.

Essentially, I want to include 16 variables on my chart, 1 bar for each
variable, and the four categories that make up each variable stack on
each other. I am looking to have the variable name up the left side of
the graph (ordinarily the Y axis), and the % axis on the bottom of the
graph (x-axis.) For simplicity sake, lets call the categories of each
variable C1-C4. Using 0% as the origin, I want the categories 1 and 2
to be to the left of the line (stacked on each other) and categories 3
and 4 to be to the right of the line, stacked on each other as well.
The sum of all of the absolute %'s will equal 100 for the variable.

There are a few things I am hoping that you can help me with. First, I
do not want to show the axis as ranging from -100% to +100%. Id prefer
it to look like 100% counting down to 0% and then back up to 100%.
Second, I want the label of each variable to be outside of the graph,
or at least not on the "zero axis", rather I want to position each
label so it can be clearly read.

Are there any special things I can do to trick excel into making the
graph the way I want it to look?


--
Btibert
------------------------------------------------------------------------
Btibert's Profile: http://www.excelforum.com/member.php...fo&userid=8559
View this thread: http://www.excelforum.com/showthread...hreadid=384973