Though I have read Mr. Peltier's essays on why not to use dual axises (hope I spelled that right...), I still would like to experiment with a chart I am toying with. Does anyone know of a simple tutorial or explanation I can read to get me going on how to construct a second axis and assign a series to it?
Thank-you!
how about this one from the MS office help files: http://office.microsoft.com/en-us/ex...149.aspx?CTT=1
Originally Posted by shg
Thank-you!
Would have been a bit happier if it were focused on handling in vba, but I suspect I am 90% there by running the macro recorder while following the steps, then cleaning up. Who knows, I just might learn more than if I had the shortcut!
Your original post did not mention VBA, so I apologize for that. I don't do a lot of VBA programming with charts, but you may find this from the VBA help files (http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx) useful - in particular how to use the Axes method to access the different axes in the chart.
to move a series to the secondary axis use
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