If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|