Phased Bar Chart

[runyan32]

This may be a tough one... I have found no resource yet to assist with
creating my report in Excel.

I am trying to create a barchart report in Excel that depicts the
following:


Analysis Design Development
Project 1 XXXX30%X XXXX20%
Project 2 XXXX80%XXXXX XXXX60%XXXXX XXX20%

Hase anyone encountered this situation before an resolved it?

Thanks,
Runyan

 

[Jon Peltier]

Quick answer (gotta run, sorry).

It's a stacked bar chart, with two bars per item, adding to 100%. For
example, Proj 1 has Analysis (visible) of 30% and Analysis (invisible)
of 70%, Design (visible) of 20% and Design (invisible) of 80%), etc.
Make the bars invisible by formatting without border or fill.

Post back if this wasn't clear enough.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[runyan32]

Jon,

Thanks for taking the time and replying. I believe that I understand
your solution, however I am still not getting it to work.

I created the following data set:



Analysis Design
Development
Project 1 100% 0% 80% 20% 15% 85%
Project 2 50% 50% 10% 90% 0% 0%

I expected to get a stacked bar chart, where I format the percentages
thare are incomplete to invisible.

However, in the graph that I described below, Projects and Phases
(analysis, design and development) are on the X,Y axes. Percentages
should be in the graph.

With the dataset that I have as outlined above, I can only get Projects
or Phases on the Axes with % on the other axis.

Am I formatting my dataset incorrectly?

Thanks,
Brian

 

[Jon Peltier]

Brian -

Set the data up like this, with your labels over the data for the
completed part of each pair and blanks over the incomplete part (or make
up six appropriate labels):

Analysis Design Development
Project 1 100% 0% 80% 20% 15% 85%
Project 2 50% 50% 10% 90% 0% 100%

Make a stacked bar chart of this data, including the first row of
labels, with series in columns. Add some formatting, including data
labels (using the value option).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______