Charting with non contiguous columns

[David Hopper]

Trying to create a chart using information from columns that are not
next to each other

I need the information from Columns C, E and L. Rows 1-8 as an example

Can that be done and if so how?

Any help appreciated.

David Hopper

 

[John Mansfield]

David,

First, create a chart based on the data in column C. Once that chart is
created, click on the chart (make sure it is active) and - going to the chart
toolbar - select Chart -> Source Data. On the Series tab of the Source Data
dialog box, select the "add" button. In the values selector (combination
box) choose the range in column E. Once the column E range is selected hit
the OK button and both ranges should now appear in your chart.

Repeat the same process to add the data in column L to your chart.

 

[Jon Peltier]

A couple other ways:

Starting with the chart based on column C, copy the data in column E, select
the chart, and use Edit menu > Paste Special to paste the data as a new
series. Repeat with the data in column L. (You could use simple Paste, or
you could drag the data and drop it on the chart, but Excel usually does
something else with it than I intended.)

Select the data in column C, hold Ctrl while selecting the data in E, and
keep Ctrl down while selecting the data in column L. Now you have three
discontiguous ranges selected. Create your chart and it will use the three
ranges. Note: the ranges must start and end in the same rows, or Excel won't
let you make the chart with the multiple ranges.

- Jon

 

[David Hopper]

Thanks very much for the help.

A couple other ways:

Starting with the chart based on column C, copy the data in column E, select
the chart, and use Edit menu > Paste Special to paste the data as a new
series. Repeat with the data in column L. (You could use simple Paste, or
you could drag the data and drop it on the chart, but Excel usually does
something else with it than I intended.)

Select the data in column C, hold Ctrl while selecting the data in E, and
keep Ctrl down while selecting the data in column L. Now you have three
discontiguous ranges selected. Create your chart and it will use the three
ranges. Note: the ranges must start and end in the same rows, or Excel won't
let you make the chart with the multiple ranges.

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