Graph - comparing values of 2 series while adding an attribute for each compared values

[Chen G]

Hi,
Here is the problem - There is a graph I have to create, based on the
following information:

I have projects names, and each project has the following data:
1. Estimated cost.
2. Actual cost.
3.Status, which can be one of 3: a. over with b. in progress c. per
demand

I need to put the data on a 3D column graph, in a way that each
project will have 2 columns that compare estimated and actual cost,
but the problem is I also need to put some kind of an attribute on
every project which reflects its status. How do I do that?

Thanks in advance,
Chen.

 

[Jon Peltier]

Chen -

I'd suggest a 2D chart type instead of 3D, because it's not easy to make a 3D chart
that doesn't distort the data.

To get your attribute: plot the two cost series, then on one of them, apply data
labels for Completed, In Progress, or Per Demand. These labels can be in another
column next to the two cost columns. Use one of these third party add-ins to apply
the cell labels as series data labels:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

These are easy to install and use.

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

 

[Chen G]

Jon,
You're the best. Thanks a lot !!!

Chen.

Chen -

I'd suggest a 2D chart type instead of 3D, because it's not easy to make a 3D chart
that doesn't distort the data.

To get your attribute: plot the two cost series, then on one of them, apply data
labels for Completed, In Progress, or Per Demand. These labels can be in another
column next to the two cost columns. Use one of these third party add-ins to apply
the cell labels as series data labels:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

These are easy to install and use.

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