View Single Post
  #1  
Old May 4th, 2010, 04:38 PM posted to microsoft.public.excel.charting
Joe M.
external usenet poster
 
Posts: 168
Default One Column on 1st y-axis and 3 lines on 2nd y-axis

Hello,
On Excel 2003 I am using the custom chart "Line-Column on 2 Axes". I would
like one column (series 1) for the first y-axis and 3 lines (series 2-4) for
the 2nd y axis. It seems that when adding series, that 2 columns are
automatically created when you exceed 2 series. Every seried added after the
second series results in lines for the 2nd y axis. If I delete one of the
first 2 series (columns) then the next series which is a line is
automatically converted to a column. My desired end result is to have only
one column on the 1st y axis and the 3 lines on the 2nd y axis. Can someone
help with this? I hope I have explained it sufficiently.

Thanks,
Joe M.