I resolved this issue.
I did a loop that checked for null cells. The trick was that and IF statement that checked for nulls had to be placed in front of EVERY line that effects a series.
Hi All,
I'm exporting a table from Access into separate Excel sheets to be plotted and graphed. The problem I am running into is that on about the 20th export it is trying to plot a chart that is missing Series(4) of 7. Therefore, there is no data to plot. I know this is problem a pretty...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.