Highlighted
Absent Member.
Absent Member.
483 views

[archive] Modifying Xvalue of Chart in Excel

[Migrated content. Thread originally posted on 09 January 2008]

I am trying to adjust the Xvalue of a chart but can't get it to work.


MODIFY Serie @XValues "=Weekcijfers Aerosols'!R15C3:R32C3"

When I do MODIFY Serie @XValues "test" it works fine.

Can someone tell me what I am doing wrong.

Thanks
Andre
0 Likes
2 Replies
Highlighted
Absent Member.
Absent Member.

RE: [archive] Modifying Xvalue of Chart in Excel

XValues are supposed to be either a variant array (see example of how to create a safearray in documentation using C$SETVARIANT) or a handle of a range.
The reason your latter example works, is because the COM engine apparently is forgiving and accepts the "test" as a single item safearray.
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Modifying Xvalue of Chart in Excel

Yes it works with handle Range.

Thanks,
Andre
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.