+ Reply to Thread
Results 1 to 2 of 2

Continuous Range of Data

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    2010
    Posts
    16

    Continuous Range of Data

    Trying to graph the effect of an exchange rate on profit/loss for a portfolio. My charting skills are fairly poor and the only way I've been able to do this has been dragging out several thousand values (ranging from about 0.64 to 0.96) against the profits that each rate produces.

    Is there some way I can set it to a continuous range (from 0 to infinity) rather than manually entering the exchange rates? Obviously in my chart I'll only show a fraction of these but I need to be able to show data for basically any exchange rate.

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: Continuous Range of Data

    IS there a formula that calculates your exchange rate?


    I would simply put a max of 12 rates down, then have the exchange rate below it.

    Then assign a toggle button to count up/down on the first cell in the series and each one after counts +.01 or whatever the change is between them.

    This way you are not wasting space with stuff you wont look at unless you want to see something specific. This is a window to that giant range you are thinking of.

    Infinity sounds like you are wanting to crash the system.

    If you were to build something that wrote in everything (Which you could in VBA) you could potentially crash your PC - not the best route -

    Look into using a spin button in the Form controls on the developer tab. You can assign a max/min range and then go from there -
    -If you think you are done, Start over - ELeGault

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 02-20-2012, 05:42 PM
  2. How to filter & sort columns to get data in a continuous range
    By Saarang84 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-02-2010, 06:42 AM
  3. Replies: 9
    Last Post: 02-24-2010, 07:20 AM
  4. find continuous data range
    By ConfusedToo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2009, 11:48 AM
  5. [SOLVED] Can I select whole rows of non-continuous range data?
    By muzzaman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2006, 07:00 PM

Tags for this Thread

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