Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2005
    Location
    London, Gtr London, United Kingdom
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Line Chart (2000)

    I was wondering if its possible, when formatting the X axis, in the Format Axis Dialog, Scale tab, rather than manually punch in numbers, have the number referenced from a specific cell for the maximum and Minimum values, i.e. Minimum: =A1 (although I know this wont work)!

    Many thanks

    Thom

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Line Chart (2000)

    No, but you could run a macro:

    Sub SetScale()
    With ActiveChart.Axes(xlCategory)
    .MinimumScale = Range("A1")
    .MaximumScale = Range("A3")
    End With
    End Sub

    You could even call this macro from the Worksheet_Change event if the relevant cells have changed, so that the chart is updated automatically.

  3. #3
    Star Lounger
    Join Date
    Nov 2005
    Location
    London, Gtr London, United Kingdom
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Line Chart (2000)

    Thanks Hans. As ever, this works really well. Something slightly different, but related to what i'm trying to achieve. Say I have a long list of dates in a column, A1 downwards, I want B1 to be a copy the last value in column A, but column A is expanded each week, how would I go about this. (if that makes sense!) I'm assuming it's something to do with Dynamic Ranges, but i'm really not good with those at all!!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Line Chart (2000)

    Try this formula in B1:

    =INDEX($A:$A,MATCH(9.99999999999999E+307,$A:$A))

    and format B1 as a date.

Posting Permissions

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