hello -
I have a workbook created in Excel 2003 that does a lot of data manipulation and presentation by dynamic pivot table creation and charting, controlled by a single userform. It is all VBA, no worksheet functions or static graphs at all - everything built at runtime.
My problem is that a series of stacked bar charts created by adding series from output pivot tables are not fully functioning in 2007. The seriescollection.Name is pulling the correct name, and the seriescollection.Value is sending the correct value, but no bars show up and series formatting does not occur. Oddly, the legend is always correct and there is no error - the data simply isn't charted. Do I need to change how I reference the series data?
Applicable code:
Thanks for any help - I feel it's something easy, like a different object reference, but haven't had any luck.
Bookmarks