Graph Data Values

M

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
 
D

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.
 
Top