Thread: Auto populate chart from active cell

I have thirty cells (A1 - A30) with part numbers and columns B, C and D with sales data. There is a 'master chart' which takes up the rest of the screen and it is populated by ticking a check box next to the part number. This reads the data into the array from where the chart sources its data.

Is it possible that the array can autopopulate by 'reading' which cell is active so that at the user arrows down the cells in column A the sales data for that part comes up in the chart?

You should be able to use the Selection_Change event.

If you need more help can you post workbook example.

Hi Bob,

maybe this will give you some ideas:

http://spreadsheet-toolbox.com/libra...ell-selection/

cheers,