Results 1 to 3 of 3

How to show different numeric intervals on a vertical axis in a chart?

This is a discussion on How to show different numeric intervals on a vertical axis in a chart? within the Excel Questions forums, part of the Question Forums category; I have a chart that ranges between $1m and $250m costs so currently the vertical axis is set at 25m ...

  1. #1
    Board Regular
    Join Date
    Sep 2015
    Posts
    91

    Default How to show different numeric intervals on a vertical axis in a chart?

    I have a chart that ranges between $1m and $250m costs so currently the vertical axis is set at 25m intervals to keep the chart small because I need to put it in PowerPoint. Is there a way to have $1m-$25m in $1m intervals so you can see the $1m cost (can't see it currently) and then have $25-$250m in $25m intervals all in the same chart. Thanks in advance!

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    29,785

    Default Re: How to show different numeric intervals on a vertical axis in a chart?

    I'd suggest reading Jon's article here: Broken Y Axis in an Excel Chart - Peltier Tech Blog

  3. #3
    Board Regular
    Join Date
    Sep 2015
    Posts
    91

    Default Re: How to show different numeric intervals on a vertical axis in a chart?

    Thank you for the information.

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
  •  


DMCA.com