View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Defining scale on y axis

Hi Sarah,

One way is to use some dummy series to create the lines yourself.
After you have created the lines you can turn off both the Yaxis values
and the Yaxis gridlines. Click on this link to find out more.
http://peltiertech.com/Excel/Charts/...s.html#AddLine

HTH
Martin