+ Reply to Thread
Results 1 to 2 of 2

Excel graphs--manipulating the scale

  1. #1
    Registered User
    Join Date
    06-12-2018
    Location
    Provo, Utah
    MS-Off Ver
    2016
    Posts
    1

    Excel graphs--manipulating the scale

    I'm trying to create a report on excel using a line graph with 4 different sources of revenue. One of the sources jumps significantly above the other 3 making them difficult to read. Currently, the y-axis goes from 0 to 5 million with a scale of 500,000. One revenue jumps quickly above 3 million and the others remain below 500,000. We would like to make the part of the graph from 0 to 500,000 larger relative to the 500,000 to 5,000,000. Any ideas on how to do this without creating a secondary axis?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Excel graphs--manipulating the scale

    Would you consider using a panel chart? https://peltiertech.com/Excel/Charts...venScales.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Auto scale graphs
    By hpatel517 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-05-2017, 12:39 AM
  2. [SOLVED] Help with VBA to update y-axis scale in graphs
    By clockhart10 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-29-2014, 12:02 PM
  3. Replies: 1
    Last Post: 04-04-2012, 03:39 PM
  4. Likert Scale Graphs
    By ranimudaly in forum Excel General
    Replies: 1
    Last Post: 08-08-2011, 10:55 AM
  5. Dynamic Y Scale in Graphs
    By aries in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2010, 11:40 AM
  6. Ensure Sensible Axis Scale When Creating Graphs Programmatically
    By chergh in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-15-2010, 10:44 AM
  7. Excel 2007 : Scale of x-axis on column graphs
    By cjsmith in forum Excel General
    Replies: 2
    Last Post: 12-08-2009, 05:21 AM

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