I note Mynda's comment in the lesson about Secondary Axies about Excel not showing (by default) which data series is plotted against which vertical axis on a two axis chart, and agree that it's an issue. Wouldn't it be smart for MS to enhance Excel so that it either appended something like "(LHS)" or "(RHS)" to each legend label to indicate the relevant axis, or grouped the legend labels by axis - after all, Excel knows which series is on which axis??

In the absence of Excel doing it automatically, I have taken to appending "(LHS)" or "(RHS)", as appropriate, in the label for each data series.

I'd be interested to know what anyone thinks about this.

Cheers

Col