Thread: How to use non-contiguous cells for horizontal axis?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default 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?

Reply With QuoteReply With Quote