Thread: 2 different currencies, secondary y axis

Hi there,

how's things?

I'm new to excel and am currently designing a few sheets and charts for the controlling department ...

I would like to have the different expenditures for each month in a stacked column and over the x-axis for the 12 months

on the left y-axis I would like to have it shown in EUROS and on the right secondary y-axis converted into another currency by a fixed exchange rate (so I just need the scale for a clear overview not for that much accuracy)

thanx a lot in advance

cheers,

T