New data, need macro to reformat chart to pull only pertinent data

[jrembold]

after entering the new data and changing the parameters of what data is being collected I got this code.

Please Login or Register  to view this content.

While this worked for this one specific instance, is there a way to make it format the chart only around the numbers. Because our sheets are constantly changing we fill everything with #NA until it gets filled by data.
Thanks everyone!!

[Kaper]

You gave neither dummy workbook to experiment with, nor exact description where data starts (or can start) etc. but lets try anyway

Please Login or Register  to view this content.