Jon,

Thank you very much for the reply. I don't know if I did something wrong.
What I did was to download your InteractiveChartCreation.zip file and extract
it. After I opened interactiveChartCreation.xls and enabled macro, I used
mouse to drag a region where I want the chart to be drawn, then click 'ok' in
the 1st input box, but everytime I moved my mouse pointer to the input box,
it showed a 'select icon' (four arrows in up, down, left and right
direction), so I end up selecting the input box object and nothing happened.
The same happened when I selected the data in the 'data sheet' and tried to
click 'ok' in the 2nd input box. Did I do something wrong? Thank you very
much for your time. I don't have other excel version to try.



"Jon Peltier" wrote:

This worked fine in a test I just ran. Did this work for you in Excel 2003?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"turen" wrote in message
...
I am trying create a chart 'on the fly' based on the user selected data
range
in Excel 2007. I was trying to use Jon Peltier's 'interactive chart
creation' VB scripts. Somehow it does not work on Excel 2007. After
Jon's
interactiveChartCreation.xls opens, both input boxes does not work,
meaning
one can not input any data by mouse selection. I tried to click 'ok', but
it
only selected the input box. I hope Jon or some one else can see this and
offer some help. Thank you all very much for your tips.