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

Time Scales on Horizontal Axis - Excel Charts 1
Excel 2007 - How can I switch the data on vertical and horizontal 1
Horizontal Axis Options Changing 6
Overlay charts in 2007 2
Restoring Horizontal Axis Labels 1
Excel 2007: Line where a gap should be, but only when plotting on ahorizontal date axis 2
How do I force a secondary horizontal axis to act as a date axis? 5
Horizontal (Category) Axis 6

Top