Graphing Question - Area Graph with 2 variables

[sooroo]

Hello,

I am trying to create an Area graph in Excel 2000.

Here is my data series:

Average Turnaround Time for Phase 1, 2, 3: 35, 65, 70
Total Projects in Phase 1, 2, 3: 19, 32, 17

I want Turnaround time to be on the X axis and Total Projects to be on the Y axis. Then I want the 3 Phases to flow into each other, i.e. the first phase is 35 units wide, the 2nd phase picks up where the last one dropped off and is 65 units wide and so on.

I want to be able to tell from the width which phases take longer and from the height, which phase is the most populous. I've been searching for a while, and I can't find a good way to do this. Ideally it would be an area graph, but columns would work too if their widths could be manipulated.

Thanks so much for the sounding board.

 

[sooroo]

Sorry, I don't understand. Is it required to name the cell that has this formula or is it optional? I've named cells before, and I know it can be useful, but I am still having trouble with this function.

 

[tusharm]

No, the formula is not entered in a cell. It is entered in the Names dialog box. See the step by step instructions in the two links I posted earlier or see Stephen's working example.

 

[sooroo]

I think I'm getting it! I have been able to enter the new series and graph them on the sheet. However, the problem I'm having is when they are displayed, all the new series are black in color, even though the legend says that they should be various bright colors.

I don't know if this is because I added them to the chart on the tab where you name the series and put in labels for the x axis. I have been trying to look for answers to this, but I haven't found a solution yet. Since I don't know how to replicate this graph, (I am only modifying his model), I can't figure out what is going on because much of the data is not shown.

Thanks to Tushar for getting me this far, but I still have a little ways to go!

 

[sooroo]

Never mind, it was a user error. I never thought I would be able to complete this.. but it's done!

Many thanks to Tushar and Mr Excel board!! ray:

 

[tusharm]

You are welcome and congratulations on your perseverence. It paid off in the end, didn't it?