View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 3 different scales on the Y-axis

On Wed, 4 Jul 2007 14:32:02 -0700, coastal
wrote:

I have three different columns that I want on one chart to show that they all
follow the same trend. Is there a way to have all on a line chart but so
that the smallest numbers (last column) don't disappear into the x-axis line?
Basically want three lines but all in the middle of the chart showing spikes
& lows.


ex:
client A B C
c1 1000 100 1.0
c2 2400 200 2.0
c3 1500 150 1.5
c4 3000 300 3.0


Perhaps you could use a logarithmic scale?
--ron