Skip some columns when creating a chart
 

In a large spreadsheet how do I keep the first column, skip the next 10
columns, include the last 10 columns while creating a chart? I prefer not to
Hide the data in the spreadsheet. The chart is not embedded in the sheet.

Mike -

Select the data in the first area, then hold the CTRL key while
selecting the data in any subsequent areas, then launch the chart wizard.

You can also do the CTRL key thing when selecting a range in the Data
Range tab of the Source Data dialog (step 2 of the Wizard).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

MikeJ wrote:

In a large spreadsheet how do I keep the first column, skip the next 10
columns, include the last 10 columns while creating a chart? I prefer not to
Hide the data in the spreadsheet. The chart is not embedded in the sheet.

It seems that very few people are aware of the "Series" tab that
appears in Step 2 of the Chart Wizard:

Click on the "Series" tab
Click on "Add", to add a single data series
-- or click "Add" multiple times to add several data series
Click in the windows for "X values" and "Y values", and define the
ranges you want, for each data series.

Ranges for data series can now be anywhere in the spreadsheet, need not
be in adjacent columns, and can even have different X-value ranges.
Sweet, blissful freedom!

Mark

If people are like me, they're in a rush for the 'Finish' button.

The series tab is also available through Source Data on the Chart menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

redbelly wrote:

It seems that very few people are aware of the "Series" tab that
appears in Step 2 of the Chart Wizard:

Click on the "Series" tab
Click on "Add", to add a single data series
-- or click "Add" multiple times to add several data series
Click in the windows for "X values" and "Y values", and define the
ranges you want, for each data series.

Ranges for data series can now be anywhere in the spreadsheet, need not
be in adjacent columns, and can even have different X-value ranges.
Sweet, blissful freedom!

Mark