Line chart to automatically update its data range based on changes in a single cell value

Hi guys,

I want my worksheet to update one of the line chart used in it when a value of a single cell in the worksheet changes.

Please see the attached excel sample file below for better understanding.

Can anyone help?

Cheers,

Hi,

you can use the OFFSET-function to achive that.
Attached please find a sample which uses a VLOOKUP to determine which value the user entered and based
on this, the chart data is offset by x-number of rows.

Hope this helps.

More charting stuff you find at: http://www.pimpmychart.com

Regards

Holger

Line Chart OFFSET.xlsx

Hi pimpmychart,

I used the offset function and got what I want. Your sample file above was very helpful in understang the function.

Thanks.

Regadrs,