Hello everyone,
Here is my code:
I want to set legend to the right side of the chart but only IF the chart already doesn't have a legend. I've tried multiple ways of doing this. Examples like "If Legend = False then" and also been trying with "Else" . How are you suppose to write this properly?Please Login or Register to view this content.
I also want to Plotarea size depending on which kind of graph it is.
Please Login or Register to view this content.
Can you do that in the same macro? What I trying to do is to have 1 plot area size for a column graph and a different one if it's circle diagram but in the same macro. Hope this makes sense haha.
Book1.xlsm
Thanks in advance,
Joachim
Bookmarks