Creating chart series using variables
I would like to add series to a chart based on variables. Some code below to show what i want to graph.
But I would like to assign the name, XValues and Values show above based on variables X, Y, a, b
Please Login or Register to view this content.
It's the syntax that i can't get correct. I have a reasonable amount of VBA experience but this one always gives me trouble.Please Login or Register to view this content.
Schwizer
Last edited by vlady; 01-15-2013 at 07:32 PM.
using your example:
Please Login or Register to view this content.
Last edited by vlady; 01-15-2013 at 07:32 PM.
I run into trouble because my variables are numbers not letters and I would prefer not to write a case select statement to convert numbers 1-26 into their letter counterparts.
sorry, I misunderstood what you were asking. There are numerous ways to solve this issue, one of the most straight-forward is to use R1C1 notation in the formula:
hopefully I put all the quotation marks and ampersands in the rights spots but I'm sure you get the point!Please Login or Register to view this content.
Thanks, that's what i needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks