How would I change this code so it would work? It stops at Activechart. SeriesCollection(1).Select
Please Login or Register to view this content.
And I did the for loop becuase I want the active chart to be selected (I wouldnt know the name of the chart). Any help would be greatly appreciated.
would be great if u provide sample workbook it will help us to provide perfect solution and to test as well
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
I would If I could but the data is confidential. I just somehow need the gap width of the active chart to be turned to 0. That's all
replace some your below code
with below onePlease Login or Register to view this content.
Please Login or Register to view this content.
It works up until I get toAny thoughts on why?Please Login or Register to view this content.
without activating/selecting the chart your trying to select the groups due to that coding getting Error
Well, I keep getting the run-time error 1004: Invalid Parameters. I'm clicking on the chart and running the macro and it still isn't working.
in which code your getting error ?
did your replace my provided code with yours ?
Nevermind! My series were not numbers which is why it wasn't working. They were labeled with text. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks