Excel 2007 : Specify Chart Data Range using an IF Formula

Hi Søren,

I sort of understand how to make Dynamic Chart Ranges using the OFFSET Formula, which is how I assume I would need to do this, but I'm unsure how to link these to a specific cell.

I've attached a simple sample. What I would like to do is for the graph to plot using the data in cells B10:F12, when 'Region' appears in cell C4 and for the chart to use the data in cells G10:P12, when 'Area' appears in cell C4.

I'm unsure how to link cell C4 to the dynamic range and would be grateful for any help.

Many thanks