J Jeff Jun 10, 2009 #1 This was easy in ocf2003, and remains an option for the vertical axis in Excel/Ofc2007. What about the horizontal axis?
This was easy in ocf2003, and remains an option for the vertical axis in Excel/Ofc2007. What about the horizontal axis?
A Andy Pope Jun 11, 2009 #2 Hi, In xl2007 SP2 I was able to create a column chart with the category labels coming from a non contiguous range. =SERIES(Sheet1!$B$1,(Sheet1!$A$2:$A$5,Sheet1!$A$8:$A$10),(Sheet1!$B$2:$B$5,Sheet1!$B$8:$B$10),1) Cheers Andy
Hi, In xl2007 SP2 I was able to create a column chart with the category labels coming from a non contiguous range. =SERIES(Sheet1!$B$1,(Sheet1!$A$2:$A$5,Sheet1!$A$8:$A$10),(Sheet1!$B$2:$B$5,Sheet1!$B$8:$B$10),1) Cheers Andy