Graph Data Values

[mark curtis]

I am trying to create a pick and mix graph that shows forecast spen
against actual spend by a selected business area.

I somehow want to create a graph on the fly based on the selections fo
example:

If I choose company one and want to see the contracted data I want th
graph to pick up the forcasted contracted Labour, Passthru and Othe
and show the combined contracted actuals; See attached;

and if i then choose company 2 then graph will pick up the releven
ranges?

HELP!!

Attachment filename: help.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=55959

 

[Debra Dalgleish]

You could select the relevant data for all three companies, and create a
chart from that.
Then, select a cell in the table, and choose Data>Filter>Autofilter
From the dropdown list in the first column heading, choose Custom
From the first dropdown in the Custom dialog box, choose 'Begins with'
In the Text box, type Comp1
Click OK, and the chart will display the data for Company 1

To make the selection easier, you could add a column to your table, and
extract the company name from column J, e.g.: =LEFT(J6,5)
Then, filter on that for the company name.

 

[mark curtis]

but how do i split the graph to show actuals and forecast combinatio
graph

 

[Debra Dalgleish]

If you stagger your data, you can create side-by-side stacked columns.

Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

and the following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?id=214119