Results 1 to 2 of 2

Thread: axis automatic range and grid line increments

  1. #1
    New Member
    Join Date
    Nov 2018
    Posts
    25
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default axis automatic range and grid line increments

    Hello,

    Does anyone know the formulas excel uses to develop and show an axis range, major grid lines, minor grid lines, and increments when graphing charts? Not sure if it matters, but I'm specifically trying to figure this our for a scatter chart type.

    Thanks in advance!

  2. #2
    Board Regular
    Join Date
    Jan 2014
    Location
    Pittsburgh
    Posts
    1,073
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    1 Thread(s)

    Default Re: axis automatic range and grid line increments

    Try "How Excel Calculates Automatic Chart Axis Limits" by Jon Peltier, https://peltiertech.com/how-excel-ca...t-axis-limits/.

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
  •