I have been asked by my manager if i could write a progrma that
1. automatically generates a chart on a seperat sheet
2. stores the information into a seperate sheet.

This is where i am having problems. i wa to store the information left to right top to bottom but the information i have is goning straight down and has spaces inbetween cells.

I would like a excel to store my information and runs the chart from my top line when i use a auto filter.

can this be done.

i have tried numerous ways but i can not seem to store the information in the next blank cell and i dont know how to run the chart off the first filtered cell. ( i will be filtering on the date and what ever appears i want it to make a chart for them).

i know this sounds complete but if you need my spreadsheet by all means i can send it through. it will look easier if you can see it i think.