Charts using nonconsecutive data

[whocares]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How do I chart select rows of data that are not next to each other. Previously I could do this in the chart wizard, but that is gone (I think). I just need a field to edit the reference cells and should be ok... can't find that....

 

[CyberTaz]

Before creating the chart select the first row of data as normal, then drag
from beginning to end of each additional range while holding the Command key
to add to the selection.

Another option is to use the Name Box on the Formula Bar by clicking the
reference displayed there & typing the ranges of cells you want to select
similar to what you'd enter into a formula, such as;

C1:F1,C12:F12,C25:F25

then press the return key & create the chart.

There's also the features of the Chart Menu as well as the Chart tools in
the Toolbox> Formatting Palette.