How to use non-contiguous cells for horizontal axis?

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

This was easy in ocf2003, and remains an option for the vertical axis in
Excel/Ofc2007. What about the 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
 
Back
Top