Adding to chart data range
Visual Basic
2
Posts
2
Posters
0
Views
1
Watching
-
Hi I've been trying to find how to get a macro to adjust the size of a range of data that feeds a chart. I want the range to grow by one cell each time a new piece of data is logged. Can anyone help please?:-D Geoff Anderson
-
Hi I've been trying to find how to get a macro to adjust the size of a range of data that feeds a chart. I want the range to grow by one cell each time a new piece of data is logged. Can anyone help please?:-D Geoff Anderson
I don't think this even uses a macro, but check out this example: http://www.ozgrid.com/download/default.htm Go to this site and download the ChartByMonth.zip example.