View Single Post
  #1   Report Post  
Rain
 
Posts: n/a
Default Controlling excel chart axis

Hi,

I have automated plotting of charts of date v/s speed recorded on a
particular day with date on the x-axis and speed on the y-axis for each car
that is being tested say Focus, Escort and Ikon. The graph gets displayed
properly for the first data selected
(say Focus) from a combo box. Now, for the other selection, the graph axis
are getting reversed i.e date is getting plotted on the y-axis and speed on
the x-axis !

Is there some why to control this ?
Im using Excel with VBA.

TIA