Greetings,
If I am using a macro to auto-generate a graph, how can I make it so that the macro works for any range of data, whether there are 10 or 500 entries.
This is an example data series that I have now.
The code above, for instance, will only graph for data between 2 - 1297 cells. How can I automate this?
Please Login or Register to view this content.
Is it possible to modify this to autorange the data?
Thanks alot,
Willis
You colud define the range that you want as a name (say Area) and reference it in the code.
If this range is dynamic, you'd probably want to refer to dynamic charting in Excel. This might prove usefulPlease Login or Register to view this content.
http://www.excelforum.com/excel-char...html?p=2850714
Life's a spreadsheet, Excel!
Say thanks, Click *
If your data is continuous try
PauleyPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks