how do I create a chart using nonadjacent ranges?

F

floridamurph

I am trying to create a chart using nonadjacent ranges in Excel 2007. The
directions say to select the first range, then hold down CTRL and select the
second. When I hold down control it will only let me select one cell. What
am I doing wrong? Thanks.
 
B

Bernard Liengme

The directions are correct, when you select the second column just drag the
mouse down the column
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
VBA concatenate ranges into a new document 0
How to create a bubble chart with more than 2 variables. 0
Dynamic charts with named range Windows 8.1 0
How to make repeating drop-down lists? 2
Excel is adding 2 rows of data source together when charting 1
Sumif with named range of nonadjacent cells. 6
Copying Named Ranges in Chart Series 1

Top