2007 charting problems RLB 12/23/2008 7:15:00 PM 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.

Re: 2007 charting problems "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 12/23/2008 8:04:45 PM 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" <RLB[ at ]discussions.microsoft.com> wrote in message news:A0FF350A-1312-45B7-A890-C8A7C2759358[ at ]microsoft.com... [Quoted Text] > 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.

Re: 2007 charting problems "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/26/2008 4:50:45 AM [Quoted Text] > 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/ _______

Re: 2007 charting problems "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 12/26/2008 4:08:15 PM I wanted to give the questioner the simplest way! Merry Christmas -- Bernard "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> wrote in message news:O4DIMWxZJHA.5772[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > >> 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/ > _______ > > >