Can no longer cut/paste ranges in chart "edit data" fields?

In Excel 2007 I can no longer cut/paste cell ranges into the x and y datasets 
using the edit data tool.  Is there a way to turn this back on?  

Also the chart range resets itself to the current length of the data, 
however, in many instances I want to set an exact future range.  Is there a 
way to have excel not reset the range to what it "thinks" I want.
0
Greg7423 (349)
10/21/2008 1:30:01 PM
excel.charting 18370 articles. 0 followers. Follow

3 Replies
537 Views

Similar Articles

[PageSpeed] 19

> In Excel 2007 I can no longer cut/paste cell ranges into the x and y 
> datasets
> using the edit data tool.  Is there a way to turn this back on?

I have no problem doing what you can't. Could you provide more details?

> Also the chart range resets itself to the current length of the data,
> however, in many instances I want to set an exact future range.  Is there 
> a
> way to have excel not reset the range to what it "thinks" I want.

If you select entire columns, Excel defines the chart data range as the part 
of those columns that contain data. If you select a data range that is 
longer than the populated region, this selected range becomes the chart 
source data range. Is this what you need to do?

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


0
jonxlmvpNO (4558)
10/26/2008 1:44:12 AM
Hi John thanks for the reply...

Maybe I need to reinstall excel... 

1. For the first problem I am trying to Ctrl+c cut and crtl+v paste cell 
ranges from previous data sets into added data sets and it doesn't work (has 
always worked previously in excel.)

2.  For the 2nd problem... I am entering cell ranges with $ holders for 
example (='CPT Data - metric'!$C$13:$C$4999) and if the current data does not 
extend all the way to row 4999 the first time the data gets entered excel 
resets the range to the current range of cells with data.) On the 2nd entry 
(i.e. after going out of the edit data dialouge and returning to update the 
information) it will keep the entered range even if the cells do not 
currently have data.  Is there a way to turn off this automatic updating of 
the range?

Thanks for your help.



"Jon Peltier" wrote:

> > In Excel 2007 I can no longer cut/paste cell ranges into the x and y 
> > datasets
> > using the edit data tool.  Is there a way to turn this back on?
> 
> I have no problem doing what you can't. Could you provide more details?
> 
> > Also the chart range resets itself to the current length of the data,
> > however, in many instances I want to set an exact future range.  Is there 
> > a
> > way to have excel not reset the range to what it "thinks" I want.
> 
> If you select entire columns, Excel defines the chart data range as the part 
> of those columns that contain data. If you select a data range that is 
> longer than the populated region, this selected range becomes the chart 
> source data range. Is this what you need to do?
> 
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
> 
> 
> 
0
Greg7423 (349)
10/26/2008 5:45:01 PM
> 1. For the first problem I am trying to Ctrl+c cut and crtl+v paste cell
> ranges from previous data sets into added data sets and it doesn't work 
> (has
> always worked previously in excel.)

What exactly are you selecting to copy, and what are you selecting prior to 
pasting?

> 2.  For the 2nd problem... I am entering cell ranges with $ holders for
> example (='CPT Data - metric'!$C$13:$C$4999) and if the current data does 
> not
> extend all the way to row 4999 the first time the data gets entered excel
> resets the range to the current range of cells with data.) On the 2nd 
> entry
> (i.e. after going out of the edit data dialouge and returning to update 
> the
> information) it will keep the entered range even if the cells do not
> currently have data.  Is there a way to turn off this automatic updating 
> of
> the range?

It keeps the data range I entered even the first time I enter it. 
Unfortunately the blanks are treated as valid data, and the chart shows as 
many categories as rows specified, and the smaller amount of data is 
scrunched to the left of the chart.

If you define the existing data range (not all the way down to row 4999, 
just what contains data) as a table, and base the chart on the table, adding 
data to the table expands the table, and the chart automatically expands to 
match.

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


0
jonxlmvpNO (4558)
10/27/2008 3:30:44 AM
Reply:

Similar Artilces:

Point mode in Edit data series
When I edit my data series on a scatter chart, cell mode goes to "Point". This means for example that when I want to use the arrow keys to move between the characters in the formula in "Series X values", the cell marker on the spreadsheet moves and cellreferences are added to the formula. I saw that if I press F2 the cell mode goes to "Edit" and now I can move the marker between the characters using the arrowkeys. if I press F2 again cell mode moves back to "Point" However, for every time I edit my data series I need to press F2 to make it behave...

Cannot edit data in forms but can in tables
I have a problem! I created a database where I can only edit the data in tables. In the forms I created I can see the data but cannot edit the data. I am using 2007 that I have set so the file can be opened in 2003. The data was imported to create tables from two Excel spread sheets using the wizard. The tables are linked together and the combined data is shown in a report. This all works without a problem. Now I need to edit the data, so I created several forms all of which I cannot add, delete or edit the data. I saw under the User and Group Permissions that u...

how do I edit data in a primary table so that it will exist for a
how do I edit data so that records in primary table exist for all related records in Access building table relationships? On Sun, 22 Nov 2009 21:52:01 -0800, ginger <ginger@discussions.microsoft.com> wrote: >how do I edit data so that records in primary table exist for all related >records in Access building table relationships? It sounds like you have it backwards. Normally one would create the "parent" record first, and then (using a subform, or other techniques) create "child" records related to it. That said... the relationships between r...

Exchange 5.5
Hello to All - We have a very small network that crashed due to virus problems and is now running again: NT 4 - SP 6a, Exchange 5.5 - SP 4, 5 clients (Win XP Pro, Win 98se, Win ME) Only one of the clients (XP Pro) can still edit the data in our Public Folders, which contains Outlook Contacts. When I check the client settings, those for the one that works seem to be the same as those for the four that don't. We need to be able to enter, edit and delete the data in Public Folders from each of the clients. All help will be appreciated, John <<>> ...

Edit data in charts
Hi everyone, Sometimes edit data in Excel charts that are pasted in PP are grayed out , for example I have a PP that has 4 Excel charts 3 of them I can click on edit data and change the data for the chart but one of the charts the option of edit data is disabled . How can I enable this function? -- Best regards, Edward it is likely that the source data link is broken. do you have the original excel chart? -- Emma Bannister PowerPoint Specialist www.presentationstudio.com "Edward" <Edward@discussions.microsoft.com> wrote in message news:78AEEF8F-FB58...

How do I edit data categorylabels in a multi-level vertical axis?
...

Edit data for Excel charts is disabled
Hi everyone, I think I asked this question before but I can't find it now. I use VBA to insert some Excel charts in PP 2007, sometimes the edit data option for charts is disabled and I can't edit the data for that specific chart , any suggestion how I can me it enable again? -- Best regards, Edward ...

Edit data in saved for web workbook
I've saved for web a workbook using Office 2003, with interactivity selected. When I open the .mht file on a computer with Office 2003 I can edit the data. When I open the file on a computer with Office 2000, I'm able to open and view the file, but am not able to edit the data I've downloaded and installed Office 2003 Add-in: Office Web Components and IE6 Service Pack Any ideas? ...

Edit database...
Are asp pages used to edit and delete database entries? I have many pages for entry, but time to give access to making changes. David Yes. You can use the FrontPage Database Interface to create pages to edit and delete records. Here are some resources to get you started: http://www.spiderwebwoman.com/resources/diwtipsandtricks.asp -- ~ Kathleen Anderson Microsoft MVP - Expression Web Spider Web Woman Designs Expression Web Resources: http://www.spiderwebwoman.com/xweb/ Expression Web Wiki: http://expression-web-wiki.com/ FrontPage Resources: http://www.spiderwebwoman.co...

Double Clicking On Cell To Edit Data
Hello, I modify existing cells contents quite frequently. Using the mouse and double clicking seems to me to be extra work. Is there any way via the keyboard to get into a cell to edit its contents? TIA Jim Mac Millan Jim Cursor to, F2 Beege "Jim Mac Millan" <fly_boy_jim@yahoo.moc> wrote in message news:OOiJF%23cLGHA.604@TK2MSFTNGP14.phx.gbl... > Hello, > > I modify existing cells contents quite frequently. Using the mouse and > double clicking seems to me to be extra work. > > Is there any way via the keyboard to get into a cell to ...

Edit Data
Hi, I have a set of data and I want to multiply each cell by 1000 s want to add *1000 in about 30-40 cells together. is there any way to d it quickly rather than going into each cell manually and enterin *1000 Thank you :confused -- Message posted from http://www.ExcelForum.com Hi try the following - enter 1000 in an empty cell - select and copy the cell (CTRL+C) - select your data range - goto 'Edit - Paste Special' and choose 'Multiply' -- Regards Frank Kabel Frankfurt, Germany > Hi, I have a set of data and I want to multiply each cell by 1000 so > want to add *...

Edit Data with a Data Access Page
Hoe do I set a Data Access Page to allow data edits and entry? Common reasons why a DAP doesn't allow editing of the data: You must define the Unique Recordset property for the page's section that has the data. You must have an element bound to the table's primary key field. It can be hidden, but it needs to be on the Data Access Page if you wish to edit data. You must use an updatable query for the recordset (note: Data Access Pages are more picky in what's updatable and what's not -- a query that works in a form may not work in a page). -- Ken Snell <M...

Can't edit data in query
Hi everyone. Using A02 on XP. This may be a dumb question but I have a UNION ALL SELECT SQL query showing me all records from 3 tables [tDistributions], [tDistributionsArchive] and [tDistributionsArchiveOld]. Why can I not edit any fields? I receive an Excel file with uncashed check numbers, date mailed and payable to. I have to search through all distribution records to identify which distribution record's check did not cash yet so we can pursue payment. Because the tables are old and inherited, my unique identifier is only unique in 2 of the tables so there is a bit of sea...

Can no longer cut/paste ranges in chart "edit data" fields?
In Excel 2007 I can no longer cut/paste cell ranges into the x and y datasets using the edit data tool. Is there a way to turn this back on? Also the chart range resets itself to the current length of the data, however, in many instances I want to set an exact future range. Is there a way to have excel not reset the range to what it "thinks" I want. > In Excel 2007 I can no longer cut/paste cell ranges into the x and y > datasets > using the edit data tool. Is there a way to turn this back on? I have no problem doing what you can't. Could you provide more det...

Edit datalabel positions in a protected chart
Hi: I have a password protected chart. Users print it but do not edit it. Now, I want them to be able to edit only the position of the datalabels. How would I do it? Please help. Joy I don't believe XL supports that fine a level of control over charts. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article <936885B6-FF62-4724-87CC-C1854EE82865@microsoft.com>, Joy@discussions.microsoft.com says... > Hi: > > I have a password protected chart. Users print it but do not edit it. &g...