Prev: How do I update calenders on Office 2003 to 2010 in Excel
Next: Change default font for new entries
From: roadkill on 27 May 2010 16:57
I have a series of charts that I update every 2 weeks with 2 more weeks of
data. When using Excel 2003 I was able to drag and drop the added 2 columns
of data to the chart and it automatically incorporated them. Since
converting to 2007, I can't do this (or at least haven't figured out how).
Instead of incorporating the data it simply moves the data itself to cells
behind the chart. I should also mention that some time ago (while still in
Excel 2003) the spreadsheet stopped enclosing/highlighting the charted data
when I selected the chart (which, when it did this, allowed me to simply grab
the corner of the selected data and move it over 2 more row). Does anyone
have any ideas for making either of these features work again?
Thanks,
Will
From: Jon Peltier on 28 May 2010 14:16
They removed this functionality from Excel 2007.

Copy the cells you want to include, select the chart, and paste.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/27/2010 4:57 PM, roadkill wrote:
> I have a series of charts that I update every 2 weeks with 2 more weeks of
> data. When using Excel 2003 I was able to drag and drop the added 2 columns
> of data to the chart and it automatically incorporated them. Since
> converting to 2007, I can't do this (or at least haven't figured out how).
> Instead of incorporating the data it simply moves the data itself to cells
> behind the chart. I should also mention that some time ago (while still in
> Excel 2003) the spreadsheet stopped enclosing/highlighting the charted data
> when I selected the chart (which, when it did this, allowed me to simply grab
> the corner of the selected data and move it over 2 more row). Does anyone
> have any ideas for making either of these features work again?
> Thanks,
> Will
 | 
Pages: 1
Prev: How do I update calenders on Office 2003 to 2010 in Excel
Next: Change default font for new entries