Hoping some of the gurus here can point me in the right direction.
I have a chart that has a data series from a workbook page, I am trying to get it all in the series...but it seems that the eventual string is too long as it includes the 'page name' as well as the data I want.
If I can get rid of the 'page name' in the series string I will have no problem, but everytime I delete it out I get an error.
How can I get the data I need all in the series box? What am I missing here?
I have a chart that has a data series from a workbook page, I am trying to get it all in the series...but it seems that the eventual string is too long as it includes the 'page name' as well as the data I want.
If I can get rid of the 'page name' in the series string I will have no problem, but everytime I delete it out I get an error.
How can I get the data I need all in the series box? What am I missing here?