Chart non consecutive data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top