selecting range for charting

  • Thread starter Thread starter Jeff Melkonian
  • Start date Start date
J

Jeff Melkonian

Hi,
I would like to write VBA code so that a user can select a
subset of a large dataset (via a userform) and have the VBA
code create the chart using the subset of data. I have the
code for creating the chart and I can get the start and end
values (actually dates, with air and soil temperature to be
plotted for the time between the selected dates) for the subset
of the large dataset. The problem is creating the ranges for the
data in the selected subset so that they (the ranges) can be
used in the code that creates the chart. Any suggestions on
how to do this would be greatly appreciated. Thanks,

Jeff Melkonian
 
Hi Jeff -

In this article, Dynamic Charting By Dates:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

I show how to select a subset of a large range by entering dates in the
worksheet. Dynamic ranges locate the portion of the range bracketed by
the dates, and these dynamic ranges are plotted.

It doesn't require VBA, sorry. Of course if you wanted to make it
fancier, you could use a form for entry of the dates, maybe with
calendar controls. That would be interesting.

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