Axis Bounds
Results 1 to 5 of 5

Thread: Axis Bounds
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2013
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Axis Bounds

    Is there a way to automatically update axis bounds when new data is added to the chart?
    Thank you.
    David

  2. #2
    MrExcel MVP
    Join Date
    May 2009
    Posts
    16,390
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Axis Bounds

    Put the data in an Excel Table (List Object). Home>Styles>Format as Table.
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

  3. #3
    Board Regular
    Join Date
    May 2013
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Axis Bounds

    Thank you, but how can I decide what I want the bounds to be for the vertical and horizontal axes.

    Again, many thanks.

  4. #4
    MrExcel MVP
    Join Date
    May 2009
    Posts
    16,390
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Axis Bounds

    Let Excel choose for you. As you add data, Excel will expand both axes to include it.
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

  5. #5
    Board Regular
    Join Date
    May 2013
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Axis Bounds

    Thank you..but I want to have control over that. I guess there isn't a way.
    Thank you for trying.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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