View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] marselle1@comcast.net is offline
external usenet poster
 
Posts: 1
Default Excel Chart question using two y axes

Is it possible to create an Excel chart with primary and secondary y
axes with different ranges and have one series be plotted against the
left y axis as column and have two lines plotted against the right y
axis? When I try to do this, one of the series that I want plotted as
a line using the right y axis instead plots as a column using the
left axis and is invisible, since the values are several orders of
magnitude less than the range of the left y axis (1000s vs. a range of
1 to 5 for the right axis).

Thanks.