Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: Graph Excel - Axis break

    I have a excel graph (line graph) and a number of series data, One series is much larger then the rest thus makes the rest of the data series look straight lined,
    I need to put a axis break in the y-axis so a certain range on y-axis is hidden

    any ideas anyone
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Check out this site:

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

    Andy is one of the best for Excel charts.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Mar 2004
    Posts
    36

    Talking

    thanks gone into website and its a bit more difficult for line graph for me anyway, but looks achievable..thanks

  4. #4
    Join Date
    Mar 2004
    Location
    Athens, Hellas
    Posts
    3
    Have you tried this:

    Right click on the straight-lined series, select 'Format Data Series', then 'Axis' tab page and 'Secondary Axis'

    Maybe this will help you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •