Need to eliminate the blank cell in data range for chart

[sarohap]

Hi All Experts,

Need your help. I am creating the chart with data source (range(w6:x50)).
But every week data changes some times it goes more then 50 or less then 50.

now i want that there should no need to do any thing to change the data when i replace the data from current data with previous data.

chart should be automatically update, there should not showing any blank field in chart.

Means it should be dynamic range. there more then 25 charts..

If you require more details then please let me know.

Please please as soon as possible.

:banghead::banghead::banghead::banghead:

 

[AlexHedley]

Do you know the first cell of each range of data?

You could set the range for the chart using VBA.

Range("W6").CurrentRegion.Select