2007 charting problems

[RLB]

Is anybody having these problems, and can anybody tell me how to fix them?
1. In Excel 2003, I could select a range of cells and drag them into a
chart and they would be pasted as a new series into the chart. Is this
feature gone in 2007?
2. When I have a rotated Y-axis label, I can click on the text and see an
insert cursor, but when I start typing, only the first letter appears in the
label and the rest end up in the formula bar. When I hit enter, only the new
text from the formula bar shows up in the label.

 

[Bernard Liengme]

1) Just Copy the range, right click the chart and use Paste
2) Do not use ENTER this add a line feed; just click outside the title to
finish the edit
best wishes

 

[Jon Peltier]

1) Just Copy the range, right click the chart and use Paste

Or Paste Special to gain more control over the outcome. I've always felt
this was better than drag and drop.

- Jon

 

[Bernard Liengme]

I wanted to give the questioner the simplest way!
Merry Christmas