Excel 2007 Chart creation

  • Thread starter Thread starter Lucho
  • Start date Start date
L

Lucho

When I use the Ctrl key to select more than one range, not all of the ranges
"selected" are selected. It only selects one X axis range and one Y axis
range from several selected ranges. Do I need to activate something somewhere
to make it work right?
 
There is nothing to activate - this is a Windows not an Excel feature.

In A1:A54 I have: x, 1,2,3,4
In B1:B5 I have: y, 5, 6, 7,8
In C there is junk I do not want to chart
In D1:D5 I have: z, 4,5,6,7
I select A1:B5 in the normal way. Then I hold down CTRL and, while it is
down, I drag the mouse over D1:D5
Now I have two ranges selected and can go on to make the chart

Try it and tell us if it works
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

scatter chart won't accept primary axis 4
chart creation 4
Excel 2007 Chart creation 1
Line chart - time series - category axis date format (2007 VBA) 1
limitation of dynamic charting technique 3
Dynamic stacked bar chart not working 3
Chart distorts secondary axis when the x-axis is logarithmic 5
Using the full width of an Excel chart with two Y-axes 2

Back
Top