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?

 

[Daz]

Convert the status to a number you can display eg 0 = overwith, 1 = in
progress 2 = per demand. The numbers can then be displayed easily as another
series on the chart. Crude but it works.

Another idea I tried but could not get it to work properly is to use
conditional formatting on the project labels to display the project labels in
different colours Then if the project labels or legend can be displayed from
the worksheet without additional formatting from the graph set-up you could
have colours reperesent the different statuses. If you can get it to work
this would be an elegant solution. Hope this idea helps.