To Break Y-Axis for multiple data series

Discussion in 'Microsoft Excel Charting' started by Sheikh Saadi, Apr 9, 2010.

  1. Sheikh Saadi

    Sheikh Saadi Guest

    Hi,
    I have a lot of data in which sometimes data varies too much that some bars
    raise up to 1000s and some remain within 100s. now, to overcome this problem
    I used Peltier Tech’s solution
    (http://peltiertech.com/Excel/Charts/BrokenYAxis.html) to break the y-axis
    which works fine when I used that for single data series. Now the problem is
    my data spans through 8 categories and 12 Months. My data looks something
    like this:

    Customers Jan Feb Mar Apr May June
    AAA 25 29 12 25 29 12
    BBB 26 69 23 26 69 23
    CCC 12 23 32 12 23 32
    DDD 29 24 70 29 24 70
    EEE 19 12 12 19 12 12
    FFF 21 10 30 21 10 30
    GGG 10 15 16 10 15 16
    HHH 9 30 7 9 30 7


    Now I am lost, when my data plots over multiple data series within one
    month. Can someone help me here. I need this as soon as possible. For this I
    will be very thankful to you.

    --
    Sheikh Saadi
     
    Sheikh Saadi, Apr 9, 2010
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Eva Whitley

    Formatting a data series to run value axis to value axis

    Eva Whitley, Apr 28, 2004, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    277
    Eva Whitley
    Apr 29, 2004
  2. Guest
    Replies:
    2
    Views:
    626
    Guest
    Jun 23, 2005
  3. Guest
    Replies:
    1
    Views:
    618
    Del Cotter
    Aug 17, 2007
  4. Wrangler

    Placing an Axis Break on the Y axis

    Wrangler, Dec 28, 2007, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    994
    Andy Pope
    Dec 29, 2007
  5. Jan G
    Replies:
    0
    Views:
    517
    Jan G
    Oct 13, 2010
Loading...

Share This Page