M
Mike Caputo
I've seen this problem posted before, but my issue doesn't seem to fit any of the variants I've seen. I have a worksheet that's laid out in an improvised tree structure containing market Sectors, Groups, and Subgroups. Each "node" consists of three rows with 16 months of historical data in the corresponding columns. I have Tree and Node classes to display and get the data, all of which works fine. I'm now trying to add a feature that allows users to click on the name of an item and show a chart of its data (using Worksheet_SelectionChange). I can get the values exactly as I want them (I can't just reference the range, because the chart displays a running total from month to month rather than just the straight numbers), and the assignment seems to work fine when I'm just testing with the template I use to generate these reports. However, once I actually run the report, I get the error noted in the subject
Unable to set the Values Property of the Series Clas
This occurs in the following procedure
Private Sub SetSeriesVals(SrsType As PivotSeriesTypes, SrsVals() As Variant
Chart_Sht.PivotSeries(SrsType).Values = SrsVal
End Su
When I debug, I can get other properties of the given Series (i.e. Name, MarkerSize, etc), but no matter what I try, the assignment to the Values property doesn't work. I am basically tearing my hair out, because everything else works perfectly and this is holding up my progress. Any help would be extremely appreciated
Mik
Unable to set the Values Property of the Series Clas
This occurs in the following procedure
Private Sub SetSeriesVals(SrsType As PivotSeriesTypes, SrsVals() As Variant
Chart_Sht.PivotSeries(SrsType).Values = SrsVal
End Su
When I debug, I can get other properties of the given Series (i.e. Name, MarkerSize, etc), but no matter what I try, the assignment to the Values property doesn't work. I am basically tearing my hair out, because everything else works perfectly and this is holding up my progress. Any help would be extremely appreciated
Mik