[SOlVED]
Hi
I have a Excel Chart(s) that i create using vb.net and Excel. I am trying to get the legend to appear on the bottom of the page by the X Axis and I am using the property .SetElement(501) however i keep encountering a Com error .
What am i doing wrong. Attached is and example of what my final product should look like after my vb.net code runs. Also attached is the error.
my current Code:
Please Login or Register to view this content.
Last edited by zwheeler; 05-21-2014 at 01:28 PM. Reason: had to add code tags
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
In excel the macro recorder provides the following for setting legend to bottom
The constant msoElementLegendBottom is 104. So try that instead of 501.Please Login or Register to view this content.
501 appears to add a Data table to the xaxis which is not valid on xy-scatter charts.
hi
i tried your suggestion but i still got the same error.
thanks
Did you try changing the chart type to Line rather than xy-scatter?
Good Morning
Yes I did and i still get the same error.
HI
Thank you i got it to work.
I had to place the .SetElement after the graph had been created.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks