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.

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.

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______

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

"Jon Peltier" wrote in message
...

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______