+ Reply to Thread
Results 1 to 3 of 3

2 different currencies, secondary y axis

  1. #1
    Registered User
    Join Date
    02-12-2007
    Posts
    1

    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

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Take a look at Jon's solution ...
    http://peltiertech.com/Excel/Charts/AlignXon2Ys.html

    or, for a single chart on dual Y axes ...
    http://www.tushar-mehta.com/excel/ti...ual%20axis.pdf
    Last edited by Carim; 02-12-2007 at 09:40 AM.
    HTH
    Carim


    Top Excel Links

  3. #3
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Glad it fixed your problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1