two units on primary Y axis

[test]

Hay!!



I have spent quite some time looking for a solution and I doubt there is
one.



Is it possible to have two units on primary Y axis such us for example EUR
/USD.. For example primary Y would have values such us : 1000 EUR / 1300
USD, 2000 EUR/2600 USD etc..



If there was a way that custom format would include possibility of
calculation for unit..



tnx



Rado

 

[Andy Pope]

Hi,

Perhaps you can create a fake value axis using a dummy data series
plotted as xy-scatter. Display data labels which are linked to cells
that have the required text.
Data for series would be like,

X Y Label
0 1000 1000 EUR/1300 USD
0 2000 2000 EUR/2600 USD
etc

Use this free addin to link data labels to cell text.
http://www.appspro.com/Utilities/ChartLabeler.htm

The scales builtin values would need to be set to none.

Cheers
Andy