Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2013
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Chart - Non-Linear Scaling of Y Axis

    I have a bar chart that covers a wide range of $ data. For example from 0 to $1.5 Million. The $ are represented on the Y axis and the months (for a year) are on the X axis.

    If I have something for a particular period that is say $100K it is difficult to see it on the graph since it doesn't really show up. Also, less than $100K is even more difficult to see.

    I have tried changing the major/minor or whatever it is called to $100K and it takes up too much real estate. Is it possible to have a non-linear y axis or is there some other more viable solution.

    I am attaching a sample.
    Attached Files Attached Files

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Mitch,

    Your chart didn't have any data!

    Try googling: excel charts log scale

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Mitch,

    Perhaps your issue is due to the type of chart you had selected for the series (4 stacked column and 2 line). I changed the chart type to bar cluster column with wide ranges from 32,000 to 1,500,000 that easily fit on the vertical axis with room to spare. The major units were set to 100,000. Also added are data labels to clarify data points but a little too cluttered for my taste.

    graph4.png

    HTH,
    Maud

Posting Permissions

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