Thread: Cycling through columnar data ranges

Originally Posted by tisgrandupnorth

I've got hundreds of columns of hundreds of numbers which I need to study for anomalies, trends and patterns. I'm applying statical functions to it, but it would also be really useful to be able to briefly view a basic line graph of them.

I can highlight the column and click Chart > Line, then make that chart a worksheet, view it, then remove it, and do the same with column 'B', but i'd like to 'flick' through the columns and have it produce a line chart of them.

Is this at all possible, with macros or in-built features, in Excel 2007?

Hi,

you could setup a small area that selects the required range from your data to be the chart, something as is done in the attached.

hth
---