Thanks to mrice I've now got the auto chart creation working well. Now I want the "Title" text of the chart to be deleted & to copy the text from a cell as it's name. It'll be the month of the chart being created. I've got the reference cell text part sorted.
After the chart has been created I would like a way to either save it as an image, or lock it. The cells that show the data to create a chart can be called up whenever I want. I type the 1st of a month in a cell & all the data of that month appears. I create the chart. But when the data is changed by calling up a different month, the chart changes.
I've tried a Hyperlink to call up Paint & save it there. But there's a security "Nag" that appears & I can't get rid of it. I tried the MS solution, which didn't work, + it's a convoluted way of doing it.
It's something I'm doing for a friend who's frightened of his computer & fully automated is the way he'd like it to be
I've attached a sample
Thanks
Bookmarks