Reply to thread

Message: [QUOTE="Jon Peltier, post: 2632916"] 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 [/QUOTE]