+ Reply to Thread
Results 1 to 3 of 3

Add a line to an excel automated sliding scale chart

  1. #1
    Registered User
    Join Date
    06-02-2015
    Location
    Belfast
    MS-Off Ver
    2013
    Posts
    4

    Add a line to an excel automated sliding scale chart

    Hey everyone,

    Relative excel newbie here so excuse me if this appears stupid!

    I have downloaded from Excel's templates a cash flow template (which I attach) which has a very nice sliding scale chart in the second tab, with the data entered in Tab 1.

    Effectively I was wanting to add a few more data lines to the automated chart on the second tab.An example would be that I would like to add Accounts Receivable as indicated on line 37 of the first tab. I have tried to do this myself by naming the start, but would someone be able to talk me through adding this? This may be unrealistic etc, but any pointers would be great.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,832

    Re: Add a line to an excel automated sliding scale chart

    You need to add more Named ranges to define data range to use for new series.

    From the ribbon use Formula > Defined Names > Name Manager.

    This is one of the existing named ranges
    CashPaidOutDataValues :=OFFSET(CashPaidOutStart,,TotalDataPoints-1,1,-TotalDataPoints)

    Once you have defined the new named ranges for start and data values you can use the Select Data dialog, for the chart, to add a series and assign named range to values.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-02-2015
    Location
    Belfast
    MS-Off Ver
    2013
    Posts
    4

    Re: Add a line to an excel automated sliding scale chart

    Andy,

    Many many thanks for that! Once I knew where I was looking I was able to reverse engineer the formulae.

    Thanks again and have a great Christmas!

+ 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. Sliding Scale
    By Brad0910 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2016, 12:31 AM
  2. [SOLVED] Intercept of a line and curve in Excel chart with a log scale on the x-axis
    By Tim2468 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-29-2015, 08:18 PM
  3. [SOLVED] Sliding Scale
    By jmalia in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2015, 09:02 PM
  4. [SOLVED] sliding scale
    By allgeef in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2014, 12:13 PM
  5. Sliding scale in Excel 2003 (Difficult)
    By krutrzy77 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-19-2014, 12:33 PM
  6. [SOLVED] sliding scale???
    By GardenGrow in forum Excel General
    Replies: 6
    Last Post: 03-29-2014, 01:15 PM
  7. Replies: 1
    Last Post: 01-04-2012, 03:49 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