dynamic chart on user selected data range in Excel 2007
 

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.

dynamic chart on user selected data range in Excel 2007
 

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.

dynamic chart on user selected data range in Excel 2007
 

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.

dynamic chart on user selected data range in Excel 2007
 

Jon,

I got it now. Previously I was using your instruction sheet to do the work
and that did not work. After I copied your vb script to a new workbook. it
worked.

I am a newbie and just begin to learn Excel programming. Thank you so very
much.

Turen

"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.

dynamic chart on user selected data range in Excel 2007
 

Jon,

I got it now. Previously I was using your instruction sheet to do the work
and that did not work. After I copied your vb script to a new workbook. it
worked.

I am a newbie and just begin to learn Excel programming. Thank you so very
much.

Turen


"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.

dynamic chart on user selected data range in Excel 2007
 

That's funny, when I tested it I downloaded the zip, extracted the xls, and
ran it as is. I also copied the code from the web site and pasted it into an
Excel 2007 module. Both worked as expected. I don't understand your
difficulty, but at least you got it working.

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


"turen" wrote in message
...
Jon,

I got it now. Previously I was using your instruction sheet to do the
work
and that did not work. After I copied your vb script to a new workbook.
it
worked.

I am a newbie and just begin to learn Excel programming. Thank you so
very
much.

Turen

"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.