How to use non-contiguous cells for horizontal axis?

J

Jeff

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

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Copy addition formula of non-consecutive horizontal cells 2
How to apply the same Fixed Horizontal Scale to Both Vertical Axis 0
Excel 2007 - How can I switch the data on vertical and horizontal 1
Time Scales on Horizontal Axis - Excel Charts 1
Overlay charts in 2007 2
Secondary axis alignment 0
Secondary axis alignment 0

Top