I'm a macro newbie so I would be enormously grateful if anyone could help me solve this problem (I've tried searching various forums but not been able to adapt advice to my specific problem)
I have a worksheet with various datasets in columns which I want to plot onto a series of simple line charts. Each series represents one set of readings at 14 different frequencies, and anything from 1 to 4 readings are obtained from each subject at a particular time (as shown by the ID and date rows).
I can make the charts individually by selecting each set of columns one by one, but my dataset is very large (and increasing!) so if there's a way of doing this automatically it will save me a HUGE amount of time.
I can't seem to paste the worksheet or a screenshot of it to illustrate but can do so if helpful (and someone can explain how to! )
Thanks in advance for any help..
I have a worksheet with various datasets in columns which I want to plot onto a series of simple line charts. Each series represents one set of readings at 14 different frequencies, and anything from 1 to 4 readings are obtained from each subject at a particular time (as shown by the ID and date rows).
I can make the charts individually by selecting each set of columns one by one, but my dataset is very large (and increasing!) so if there's a way of doing this automatically it will save me a HUGE amount of time.
I can't seem to paste the worksheet or a screenshot of it to illustrate but can do so if helpful (and someone can explain how to! )
Thanks in advance for any help..
Last edited: