Update Chart table programmatically

How can I update a chart with only one manually data entry ? Let say that 3 sheets;

1.- Weekly report containing data to be plotted.
2.- Sheet containing charTable historical data and new weekly data programmatically entered in the last row of table.
3.- Chart sheet

In another words I want to enter data manually only ones (in the weeklyReport) and move the data programmatically (all sheets are in the same workbook) to the rest of the report ( chartTable) and chat sheet.

I attached a sample of my problem.

Or if you guys have any other structure to do this report, I’m open for suggestions. The main focus is enter data only time, update chart table and plot data automatically to chart.

I want to thanks in advance for the replays of this posting.

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