+ Reply to Thread
Results 1 to 5 of 5

Milestone Graph: Fit to used range only!

  1. #1
    Forum Contributor
    Join Date
    09-11-2008
    Location
    uk
    MS-Off Ver
    2010; 2016
    Posts
    396

    Milestone Graph: Fit to used range only!

    All,

    I have been working on this project for a while, and am really struggling with the last part!!
    I have developed a Project Timescale graph, which triggers of cell F2 in the same named worksheet. When this cell is changed, the corresponding values associated with that selection are auto populated in the corresponding ranges (B20:C106). This works by formula which populates the relevant figures from the worksheet called data.

    Please see attached file.

    Whilst this works great and I get the correct results, the derived graph is visually poor..... and the whole graph is really squashed up.
    Can somebody please suggest a way that the resulting graph covers (as best as possible) the whole of the area of the graph......in other words, the point associated with the last visual date is as far over the right as possible, so that I can actually see what is going on!!! I think it is to do with the ranges I am using, but I simply cannot fathom it out.

    Additionally, I would really like the “out of range” blue indicators removed, but when I try to remove them, the graph goes belly-up, and I have only included them to show the areas which are currently not required, e.g. somehow I am not omitting the unused ranges from the points which are currently plotted.

    Any additional advice to make this graph a little bit more visual, e.g. thoughts on where I should set the level of the position indicators etc would be greatly appreciated.

    I really hope that you great people can help, and many thanks for looking.

    Skyping. (A bit of a novice when it comes to Graphs!!)
    Attached Files Attached Files
    Last edited by skyping; 05-23-2015 at 01:33 AM.

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Milestone Graph: Fit to used range only!

    Hello
    Take a look at the attached file. I've created a Dynamic Project Timeline chart. This is perhaps how I might do it but if you load the chart with many more lines of data it might still become squashed. Perhaps then some sort of scroll system for the dates might be employed. If you think it's something you can work with I'd be happy to answer any questions. It uses a few dynamic named ranges which might need some explanation if you're not use to using them.

    DBY
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    09-11-2008
    Location
    uk
    MS-Off Ver
    2010; 2016
    Posts
    396

    Re: Milestone Graph: Fit to used range only!

    Thank you for your reply and excellent file DMY.

    This is fantastic, and certainly something I can use.

    I may need to employ a scrolling system, as you suggested, as there may well be a load of more point incorporated into the real data.

    So thank you VERY much for your help!!

    SOLVED.

    Skyping.

  4. #4
    Registered User
    Join Date
    05-23-2015
    Location
    India
    MS-Off Ver
    MS 2007
    Posts
    1

    Re: Milestone Graph: Fit to used range only!

    superb!!!!!!!!!

  5. #5
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Milestone Graph: Fit to used range only!

    Thank you both for the positive feedback. Glad it was useful.

    Regards DBY

+ 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. Create a milestone chart using a list of date range
    By miss_chloe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2013, 01:58 AM
  2. Celebrating another milestone !
    By Fotis1991 in forum The Water Cooler
    Replies: 8
    Last Post: 03-13-2013, 02:53 PM
  3. wohooo...another milestone!
    By FDibbins in forum The Water Cooler
    Replies: 68
    Last Post: 02-14-2013, 02:20 PM
  4. Using Excel to Add up milestone payments
    By Madball in forum Excel General
    Replies: 6
    Last Post: 10-02-2007, 07:15 AM
  5. Replies: 6
    Last Post: 01-25-2006, 02:45 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