+ Reply to Thread
Results 1 to 2 of 2

weird behaviour of automatic axis scaling?

  1. #1
    Registered User
    Join Date
    11-19-2008
    Location
    Czech Republic
    MS-Off Ver
    365 at work / 2016 at home
    Posts
    24

    weird behaviour of automatic axis scaling?

    Dear gurus,

    try this scenario...
    in column A create 100 values of "8,8" and in column B create also 100 values with value of "7".
    For those two columns, create simple line chart.

    now, you will see that there are just two lines in the chart, one in 8,8 value, another in 7.
    However automatic scalling of Y axis starts at 0... so both lines are at the top of chart .

    Now, when I change the B column values from 7 to 7,334 then the scalling updates correctly and Y axis is starting from 6,5... so all area of chart is filled.

    Why is this behaviour? why "7,334" is the limif for this scalling?
    and mainly, what can I do with that? without using VBA to change the axis minimum, and without manualy setting it?

    Thank you

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

    Re: weird behaviour of automatic axis scaling?

    Have a read of Jon Peltier's article
    https://peltiertech.com/how-excel-ca...t-axis-limits/
    Cheers
    Andy
    www.andypope.info

+ 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] Weird Textbox_Exit procedure behaviour
    By Bezzie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2016, 12:23 PM
  2. [SOLVED] Weird behaviour of column copy
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2015, 11:50 AM
  3. [SOLVED] Weird Filepath Behaviour
    By timbo1957 in forum Excel General
    Replies: 1
    Last Post: 08-05-2012, 04:56 PM
  4. Weird behaviour for a basic sum
    By barid in forum Excel General
    Replies: 3
    Last Post: 08-27-2009, 07:38 AM
  5. Weird Button Behaviour
    By roasty_1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2008, 04:34 AM
  6. [SOLVED] Excel2000: Weird behaviour in VBA
    By Arvi Laanemets in forum Excel General
    Replies: 3
    Last Post: 02-01-2006, 10:14 AM
  7. [SOLVED] Weird Cell Behaviour
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-18-2005, 02:05 PM

Tags for this Thread

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