Actually the Chart.Legend property doesn’t work in this case since it just allows to set the Overlay and Legends box position:
I need to edit the text of the elements inside the legends box and remove Secondary Chart series as well.
I have attached a zip with the files. There are 3 files:
- The template for the chart.
- The current output.
- The expected output.
You will notice that in the template there are 10 chart series: 5 primary (1 to 5) and 5 secondary (6 to 10).
It is expected that data will be related between the 2 axis. So, in the example of the expected output you will find data for 3 people, where:
Person 1 => Serie1 and Serie6
Person 2 => Serie2 and Serie7
Person 3 => Serie3 and Serie8
It is expected that series 4, 5, 9 and 10 should be deleted since were not used. Also it is expected that in the legend box each person appear only 1 time. Since I’m updating the text for the legends corresponding to the Primary Series, the legend corresponding to the secondary series should be hidden.
So as I mentioned in my first post, I don’t have issues implementing this behavior for the primary series legends, however I don’t have a clue of how to do it with the secondary series legends.
Thanks for your help.
FileSamples.zip (59.4 KB)