+ Reply to Thread
Results 1 to 2 of 2

Splitting Y-Axis into 2 for a line chart

  1. #1
    Jason
    Guest

    Splitting Y-Axis into 2 for a line chart

    Hi,

    I have a bunch of data series that I want to chart using a line graph with $
    on the y-axis and time on the x-axis. The trouble is that about half of them
    have relatively low y-values (between 0 and $100) whilst the rest have high
    values ($600-$1000).

    My question is: Does anyone know of any way to manipulate the y axis so that
    it ues a scale of, say, $20 for the 0-$100 section, and then "jump" to $600
    (with zig-zag or something on the y-axis to tell the user that the graph is
    non-continuous) and continue the chart there? Otherwise the scale just
    becomes too large or too small to make any sense of trends within these 2
    blocks.

    Many thanks for your help in advance!

  2. #2
    John Mansfield
    Guest

    RE: Splitting Y-Axis into 2 for a line chart

    Jason,

    You can apply the concepts explained at Jon and Andy's sites to your line
    chart:

    http://peltiertech.com/Excel/Charts/BrokenYAxis.html

    http://www.andypope.info/charts/brokencolumn.htm

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com

    "Jason" wrote:

    > Hi,
    >
    > I have a bunch of data series that I want to chart using a line graph with $
    > on the y-axis and time on the x-axis. The trouble is that about half of them
    > have relatively low y-values (between 0 and $100) whilst the rest have high
    > values ($600-$1000).
    >
    > My question is: Does anyone know of any way to manipulate the y axis so that
    > it ues a scale of, say, $20 for the 0-$100 section, and then "jump" to $600
    > (with zig-zag or something on the y-axis to tell the user that the graph is
    > non-continuous) and continue the chart there? Otherwise the scale just
    > becomes too large or too small to make any sense of trends within these 2
    > blocks.
    >
    > Many thanks for your help in advance!


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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