View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
coastal coastal is offline
external usenet poster
 
Posts: 25
Default 3 different scales on the Y-axis

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
--
--coastal