Charts on the Fly

[gheyman]

Good morning all.

Is there a way to make charts on the fly? My X and Y axis as well as my datarange will vary. How can I have an automated chart without the user having to define the ranges?

Much appreciated!

Greg - Orlando FL

 

[RalphA]

One way would be to select the largest range to be used, add 1 to it, and, in the row correxponding to that value, enter #N/A. Now, when you plot this, the range will be the maximum +1, but, the plotted curve will stop at the last entry, with the remaining part blank. You might try protecting the sheet, with the cell containing the #N/A protected, so it won't be accidentally removed.

 

[tusharm]

If I understand you correctly, you should be able to adapt the techniques at
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Good morning all.

Is there a way to make charts on the fly? My X and Y axis as well as my datarange will vary. How can I have an automated chart without the user having to define the ranges?

Much appreciated!

Greg - Orlando FL

 

[Jon Peltier]

You might also try the sample here:

http://peltiertech.com/Excel/Charts/InteractiveChartCreation.html