Questions

excel scroll bar not bringing up all data

Tags: Windows, Software
+
0 Votes

excel scroll bar not bringing up all data

gardener10
I followed the instruction in the TechRepublic article “10 steps to creating a scrolling Excel chart”; http://www.techrepublic.com/blog/10-things/10-steps-to-creating-a-scrolling-excel-chart/3454/#. The problem is that the scroll bar stops working at a certain point.

I have 4 years worth of temperature data. When I get to the beginning of the fourth year, the chart goes blank and the scroll bar will not bring up the rest of the data.

My property settings for the Jan 1 of the first year are: Current value =1, Minimum =1 (I also tried 0), Maximum = 1500, Incremental =5, page =30, linked cell =$E$2.

The original data table from where the Index function draws the data is 1463 rows long (minus 2 rows for the header). The ‘magic’ number where the scroll bar stops working is 995 for the current value. From a current value of 996 onwards, the entire matrix displays error messages “Ref#”.

Member Answers