Update Chart table programmatically

Posted on "Charts Forum" one replay

http://www.excelforum.com/showthread.php?t=614342

The main goal on this post is error proofing the data entry. I want to enter data ones and move it automatically, saving time and avoiding errors.

Hi

It depends upon how you want to display your chart, i.e all entries or just a subset.

If all entries then you can use the offset function for the chart ranges, e.g

=OFFSET('(2)chartTable'!B1,1,0,COUNTA('(2)chartTable'!B:B)-1)

If for example the last 12 entries

=OFFSET('(2)chartTable'!B1,COUNTA('(2)chartTable'!B:B)-'(2)chartTable'!$A$1,0,12)

where A1 has the number of entries to be displayed.

Alternatively a slider bar could be used so that all entries could be displayed by dragging the slider.

Regards


Jeff