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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"RLB" wrote in message
...
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.