As you can see above, I have data of 7000 rows in one column and I want to see graphical change for every 30 odd blocks of data. is there any easy way to insert any button or anything to move the block down when I press the arrow so that I can see the graphical changes?
Yes, that can be done. It's one of the core techniques of dynamic charts in Excel.
What you need:
A cell where the user indicates which data to show
A formula that uses that cell input to build a dynamic range
A chart that uses the dynamic range as the chart series source.
For 1: You may want to use a Spin Button or a Scroll Bar from the Developer ribbon > Insert dialog. If you use a Scroll bar, set it up so that a page change equals 30, the minimum is 1 and the maximum is the number of rows in your data set. The Scroll Bar writes its value into a spreadsheet cell. Give that cell a range name, like "SelectedBlock" so it is easier to read in formulas. (you could also let the user type in the start row of the data block into that cell manually)
For 2: Create two named ranges with these names and formula references. (Assuming your data starts in A6
Thank you very much for responding to my Query. can you please add some pictures to the point 1. in your description? I am not able to figure out exactly how to setup scroll bars or spin buttons to my data.@Ingeborg Hawighorst