Results 1 to 4 of 4

Thread: Graph of foreign exchange

  1. #1
    Full Member Simimano's Avatar
    Join Date
    Mar 2013
    Location
    South Africa
    Posts
    40
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Exclamation Graph of foreign exchange

    Hi guys!!

    On every Wednesday for the past eight weeks I have had to indicate what the exchange rate is between South Africa and the following monetary units:

    *USA Dollar
    *Euro
    *Pound
    *Pula

    I then had to write a report on what tendency prevailed in the course of eight weeks. I then have to graph the various rates.

    I was just wondering..All four can be placed on one graph, right? So how would I go about doing it on one graph?

    The example provided is only one unit on one graph..So it does not help much.

    Thanks!!

  2. #2
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,648
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12
    Quote Originally Posted by Simimano View Post
    I was just wondering..All four can be placed on one graph, right? So how would I go about doing it on one graph?
    Use a line graph.

    Looking at the four of them, you wouldn't even have to use a different colour for each currency - there won't be any cross-over points

  3. Thanks given for this post:

    Simimano (18-Mar-13)

  4. #3
    Diamond Member Justloadit's Avatar
    Join Date
    Nov 2010
    Location
    Johannesburg
    Posts
    3,480
    Thanks
    134
    Thanked 695 Times in 593 Posts
    Blog Entries
    1
    EXCELL performs this task very well. Not sure what version you have, but basically you enter each currency in 4 columns with the values going down in rows, with the description of the currency in each column heading, and the time period on the left most side of the rows. You then click the top left hand cell and with the mouse while holding the right key, drag the colour area to your last bottom cell, release the mouse. The select on your menu bar insert graphs, select a graph and click, and whala a graph appears. You can then play around with the column reference values to show your graph. EXCELL is very powerful for this type of requirement. In engineering we use this often.

    If you do a google search "How to draw a graph using excell", there are many tutorials to chose from.
    Victor - Knowledge is a blessing or a curse, your current circumstances make you decide!
    Solar pumping, Solar Geyser & Solar Security lighting solutions - www.microsolve.co.za

  5. Thanks given for this post:

    Simimano (18-Mar-13)

  6. #4
    Full Member Simimano's Avatar
    Join Date
    Mar 2013
    Location
    South Africa
    Posts
    40
    Thanks
    10
    Thanked 0 Times in 0 Posts
    Thanks for the answers

    I will most likely just do it by hand for a faster result, It will still appear neat and put together.
    I have Excel 2010, and I gave it a go the other day and it looks great and all but adding the data and extra columns and making sure everything is perfect may take a bit too long..

    I will use it in the future though, Excel is very useful indeed.

Similar Threads

  1. [Question] Foreign Exchange calculation for Foreign Income
    By anakin in forum Tax Forum
    Replies: 8
    Last Post: 31-Jan-13, 01:46 AM
  2. Google Traffic Pie Graph
    By derekjay in forum Marketing Forum
    Replies: 2
    Last Post: 25-Jan-11, 08:00 AM
  3. exchange rate
    By murdock in forum General Business Forum
    Replies: 7
    Last Post: 13-Jan-11, 01:56 PM
  4. Replies: 2
    Last Post: 09-Nov-10, 03:49 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

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