0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
1 Endorsement
Ranked #856
Ranked #107.41K
Re:
This is an issue that I've discusses many times before, but never with a conclusive solution. I am trying to programmatically change the data range for an existing chart in Excel. My code goes something like this: [CODE] With WS.CharObjects(SelChart).Chart With .SeriesCollection(1) .XValues =DataWS.Range("A1:A101") '<-----ERROR! .Values = DataWS.Range("B1:B101") End With … |