Chart non consecutive data

[Jan]

Is it possible to chart non-consecutive data. I haven't been successful in
my attempts so far. Data is in same row, ie. row 4; columns needed are H4
and J4 (need to be stacked), next series is K4 , L4 & M4. Unfortunately, I
can not rearrange the cells to make this easier.

Any help or suggestion would be appreciated. I haven't done that much
charting with Excel (2003).

TIA

 

[Tushar Mehta]

XL doesn't stack data in the same series. It stacks one series on top
of the previous.

You can simulate the effect you want as follows.

Select H4:J4 and create a stacked column chart. In step 2 of the
wizard ensure 'Series in' is set to 'Columns'.

Now, select K4:L4, copy, select the chart, select Edit | Paste
Special... Ensure you set 'Add cells as' to 'New point(s)' and 'Values
(Y) in' to 'Columns'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions