2007 charting problems

  • Thread starter Thread starter RLB
  • Start date Start date
R

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.
 
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
 
1) Just Copy the range, right click the chart and use Paste
Click to expand...

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

- Jon
 
Back
Top