Forum Discussion

Loonette's avatar
Loonette
New Member
8 years ago

Graphing Highly Skewed Data

Hello all! I am looking for some suggestions on how to make a graph of highly skewed data without the data at the lower end of the scale doesn't look almost non-existent.   Here is the data that I am dealing with:

 

 

Month/YearTotal # Detected and Blocked 

1-Jul15299
1-Aug57179
1-Sep5329
1-Oct31133
1-Nov8554
1-Dec19762
1-Jan14867
1-Feb268516
1-Mar30034
1-Apr10320
1-May30401
1-Jun13986
1-Jul8912
1-Aug18028
1-Sep8542
1-Oct34571
1-Nov13591

 

 

As you can see, February is a huge number and makes the rest of the months unreadable.  Is there a way that I can take the amount on the left axis and condense the numbers from 60,000 to 200,000?  

 

Any ideas will be great appreciated.

 

Thanks!

Lori

2 Replies

  • Loonette's avatar
    Loonette
    New Member
    8 years ago

    Hello,

     

    I am hoping that I can get some suggestions/help with graphing skewed data.  I have a chart where the month of February is huge making the rest of the months unreadable:

     

    Here is the data behind the graph:

    Month/Year                                                                          Total # Detected and Blocked 

    1-Jul15299
    1-Aug57179
    1-Sep5329
    1-Oct31133
    1-Nov8554
    1-Dec19762
    1-Jan14867
    1-Feb268516
    1-Mar30034
    1-Apr10320
    1-May30401
    1-Jun13986
    1-Jul8912
    1-Aug18028
    1-Sep8542
    1-Oct34571
    1-Nov13591

     

    Is there a way that I can condense the left axis so that the values between 60,000 and 200,000 are basically not visible, allowing the other values to not seem so miniscule?

     

    Any help with be appreciated.

     

    Thanks!

    Lori

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Loonette,

     

    Unfortunately, it is not allowed to condense a certain range of values on Y-axis. The interval of values displayed on -Y-axis is always commensurate. You may need to submit this idea here. 

     

    Best regards,

    Yuliana Gu