Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: axis breaks

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Norway
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know this is somewhat critizised from a mathematical view, but For presentationary reasons one might like to insert breaks to the axis. One might have data that accumulates in differented parts of a specter. AS one might want to compare graphs in the low area to each other and still show a graph that is tenfold higher in the same sheet.

    i would be surprised if excel had no way of doing this.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Would a logarithmic scale (under the custom charts tab) be suitable for your data?

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Norway
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Unfortunately not. A good analog to my data is chemical reactions, where you want to show speed differences beetween differnt reactions and you want to show all the reaktion with and without a catalyst. Then you will get accumuation of different reactions at low speed and similar accumulation at high speed. Lets say the y-axis is speed and the x-axis is consentration of a reactants.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't if this helps (I'm not too familiar with charts) but, if you have two series with wildly different y values, you can plot an xy scatter graph and put one of the series on a secondary y axis. If this is no good, sorry, perhaps someone else can help you out

Some videos you may like

User Tag List

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
  •