Hello all,
This is my code:
Please Login or Register to view this content.
When I use this on a xlLine graph with a SECONDARY axes, it refers the graph to Case Else even though it's xlLine, therefore it removes the Legend. Why is that?
Hello all,
This is my code:
Please Login or Register to view this content.
When I use this on a xlLine graph with a SECONDARY axes, it refers the graph to Case Else even though it's xlLine, therefore it removes the Legend. Why is that?
Hi,
When you add the second axis, the chart type changes (at a guess to a custom type)
In the VBA editor immediate window type "print activechart.charttype" with a line chart selected, and it will return 4
If you then add a secondary value axis and repeat, it will return -4111
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
-4111 = xlCombination
It can mean a mixture of chart types or use of secondary axis, regardless of chart type.
You could check the charttype of a specific series
Thanks guys, now it works!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks