View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R Tanner R Tanner is offline
external usenet poster
 
Posts: 87
Default Adjustable Axis in Excel 2007

Would it be possible to program an adjustable axis in Excel? I'm
graphing multiple indicators on a 2D chart in Exel. I'm using Drop
Down boxes to select a given category(out of approximately 100
different indicators) and I would like to have a procedure that
automatically switches a given indicator to the secondary axis when
that indicator reaches a certain value, say 25,000. This sounds like
something that would be possible, but I'm just learning programming,
so I'm not sure exactly how to do it. :)

Thanks for any feedback in advance.