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.