I need some help with a chart i am creating using vba code, i want to define the placement and size of the legend but im having difficulty do this, can anyone help
I need some help with a chart i am creating using vba code, i want to define the placement and size of the legend but im having difficulty do this, can anyone help
Last edited by PRodgers4284; 11-07-2009 at 10:09 AM.
What exactly is the problem? Error running code maybe or just not the desired result.
Post example workbook and explain further your problem.
Have you tried the macro recorder?
Please Login or Register to view this content.
Andy i have used your code and it works but i want the legend on the top right of the plot area, when i try to do this the plot area move to the bottom of the chart area, how do i put the legend on the plot area? My code is:
Please Login or Register to view this content.
More like
Top right outside of plotarea.Please Login or Register to view this content.
Please Login or Register to view this content.
Unless I'm misreading some of the code you posted Andy, you're mostly controlling the placement of the legend (top, bottom, etc.).
What I need to do is have the height and width of my legen change based on the number of series and the length of the series names. Picking that information up isn't my problem (the LEN formula isn't exactly a mystery and I already make use of some code to pick up the series count).
What I'm not sure of is how to translate that into values for height and length. Once I have that I've already used the recorder to get the code to change height and width
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
Start a new thread and include a workbook example that illustrates the problem you are trying to resolve.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks