I am fairly new to VBA, but I can't seem to find this anywhere..
Does anyone know if there is an easy way to creat a macro that selects all the charts on a page and changes them from a scatter plot back to a line graph and vice versa.
Thanks for the insight.
Does this do what you are looking for?
Please Login or Register to view this content.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
Oh wow that's great almost perfect. Except it changed my setting kinda.. I guess I should be more specific in that I need the data points for the line chart and a straight line connecting the points on the scatter plot.
I added the word markers after x1Line it works to add markers to the line chart however then the button doesnt switch back to the scatter plot again and it is stuck on the line chart.
Whereas your original code kept it switching back and forth!
sorry for the many replies, I now have the lines connecting the scatter plot so all I need is the markers on the line Chart!
Again I can get them by "myChart.Chart.ChartType = xlLineMarkers" however once it changes to that chart the macro no longer works.
Does this work?
Please Login or Register to view this content.
Yes Thank you so much!
Good job figuring out the different graph type you needed (xlLineMarkers). I am glad the last code worked for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks