Two questions really, all to do with this arduous Chart Range Edit Box.
1. Is there anyway to copy chart range sets so I can just take one line,
duplicate it two more times and then change the column names to reflect the
new columns data? My charts are X-Y's with X data from Column B or C, and
then Y column(s) can be anything, AA, BA, etc. so this drag and grab, one
box, method does not work. I used to be able to ADD a new set, then use
Copy,Paste for each line (title,X,Y) but copy, paste does not work anymore.
2. Is there any way to turn off this annoying cursor arrow problem of
adding cells when trying to edit a range line? I keep forgetting and hit an
arrow key, and end up with a totally useless range. Having to edit the line
with mouse and delete key is a real pain. At least in 2003, when you were on
the line you could edit with the cursor OR upon selection, go out to grab
cells. In 2007 you can only grab cells, which sucks when you can have up to
3600 cells to select or just want to change one column from AA to AB, etc.
Thanks!!!