Is it possible to programmatically create and open a chart when I click on a
cell in a spreadsheet? The value of the cell to be clicked will be
calculated from an array of values in another sheet in the workbook. When I
click the cell, I want to create a chart that shows a graph of the values
that the clicked cell represents. I know how to open the vba editor, but
how do I assign code to a cell? I don't want to use a User Form - I just
want to click a cell in the spreadsheet and create a chart - can this be
done?

Thanks in advance.