Changing Y Scale on Excel

Discussion in 'OT Technology' started by Peyomp, Feb 21, 2006.

  1. Peyomp

    Peyomp New Member

    Jan 11, 2002
    Likes Received:
    I am doing an expense/revenue chart, and revenues are zero for some months, and expenses during this period are small compared to huge sales later. The result is that the revenues and expenses for the first several months are totally flat lines. I would like to change the scale at the bottom of the line graph to zoom in, so that the first million is 4 times or so as large as the millions over that.

    Anyone know how to use two different scales, for the same value, on the Y axis in Excel, to show changes at small values, as well as large?

    Anyone know any charting software that can do this?

Share This Page