How to use non-contiguous cells for horizontal axis?
 

This was easy in ocf2003, and remains an option for the vertical axis in
Excel/Ofc2007. What about the horizontal axis?

How to use non-contiguous cells for horizontal axis?
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jeff" wrote in message
...
This was easy in ocf2003, and remains an option for the vertical axis in
Excel/Ofc2007. What about the horizontal axis?