Add series to existing chart

From the user's manual:

To add a chart based on data in more than one table, first select a single table or
contiguous range of cells and create a chart, then click Charts in the toolbar, and
choose a chart type. Select the chart and hold down the Command key while clicking
or dragging cells in another table to add their data to the chart.

Whoops, that won't let you choose from different sheets, just different tables on the same sheet.

Maybe there's an easier way but what I found would work is to create the chart in the first sheet then cut and paste it into the other one so you can select the second set of data.

Message was edited by: Badunit

Message was edited by: Badunit

Sparkz,

In the Sheets Pane, drag the lonely chart back to it's parent's sheet. Add the data series. Drag the modified chart back to the sheet where it was before the change.

Jerry

Yeah, duh on me. I am so used to cut/paste from years with other applications I forget how easy it is to do some things in iWork. Thanks for the reminding me and for providing a better solution.