+ Reply to Thread
Results 1 to 3 of 3

Making a chart where the number of rows will vary widely

  1. #1
    Registered User
    Join Date
    09-01-2015
    Location
    New Zealand
    MS-Off Ver
    2013
    Posts
    7

    Making a chart where the number of rows will vary widely

    Hey there.

    I am trying to make a dynamic chart based on an amortization schedule. The only problem is the data is dynamic, with the number years of the loan and the frequency of payments can both be changed.

    So if someone enters a 10 year loan with yearly payments I get a table with 10 rows but if they are calculating a 20 year loan with weekly payments there would be 1040 rows.

    I have to admit that how I got this working probably isn't the simplest method, but with my level of knowledge it was the best I could do.

    I have attached the spreadsheet on the off chance someone is willing and able to help.

    Project_Part2.xlsm


    Barry

  2. #2
    Registered User
    Join Date
    09-01-2015
    Location
    New Zealand
    MS-Off Ver
    2013
    Posts
    7

    Re: Making a chart where the number of rows will vary widely

    Ok so I have found the drop down menu for hidden and blank cells, but it seems to be assuming that the gaps will appear amongst the data, not all at the end, so it still plots a line all the way to the end of the rows.

  3. #3
    Registered User
    Join Date
    09-01-2015
    Location
    New Zealand
    MS-Off Ver
    2013
    Posts
    7

    Re: Making a chart where the number of rows will vary widely

    Solved

    Had to learn how to make an offset chart, Yay!

+ 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. [SOLVED] VBA to create a chart when data can vary in column position and rows
    By MalibuLX3 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-21-2013, 11:21 AM
  2. BAT File VBA - Vary based on number of rows in worksheet
    By mamero in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-28-2013, 03:24 PM
  3. Auto fill to last row (number of rows will vary) - SOLVED
    By artacus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2013, 11:03 AM
  4. Replies: 0
    Last Post: 08-31-2011, 09:44 AM
  5. Replies: 8
    Last Post: 02-18-2010, 05:14 AM
  6. Can Excel vary a value for me automatically and produce a chart?
    By pud1m in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-05-2007, 11:51 AM
  7. Vary colors in area chart by x-axis value
    By Deirdre M. in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-12-2005, 06:05 PM
  8. Excel Graphing With Widely Divergent Values
    By Jerry in forum Excel General
    Replies: 4
    Last Post: 03-03-2005, 11:06 PM

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