Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default Excel 2007 Chart creation

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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
Default Excel 2007 Chart creation

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Lucho" wrote in message
...
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Chart creation Lucho Charts and Charting in Excel 1 May 29th 09 05:00 PM
chart creation P. Zicari Charts and Charting in Excel 4 October 25th 07 11:16 PM
Form Creation in Excel 2007 Stan Clawson Excel Discussion (Misc queries) 2 March 19th 07 06:10 PM
Chart creation Harddrive747 Charts and Charting in Excel 2 October 23rd 06 03:17 AM
Excel chart creation biffbowl Excel Discussion (Misc queries) 0 March 17th 06 08:27 PM


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"