Charts are captured between rows and show up in powerpoint

[Guest]

First, I want to thank you in advance for reading this and helping me. I am
in a real pickle here and cannot seem to figure out what is going on.

The Problem: I am using Excel 2003. I created several charts in my excel
workbook and then proceeded to add and delete rows to move my charts and data
around. Somehow in this process parts of charts are now trapped in between
rows. The only way that I can see anything wrong in excel is if I highlight
the affected area. The line between the rows appears white. The problem
happens when I copy these charts into Powerpoint for my presentation. When I
paste the excel selection into powerpoint as a picture, parts of the graph
appear. I tried to ungroup the picture to delete the part of graph showing.
When I ungroup the picture, suddenly the whole chart is showing on the
powerpoint slide. How do I delete this "white line" with the chart data
trapped inside? I do not know how to describe this technically, but I hope
this makes sense. Has anyone ever experienced this? Thanks!

 

[Jon Peltier]

This is a common problem. Charts don't go away when you delete the rows or
columns beneath them, then merely shrink in size. On the Drawing toolbar,
click the Toolbar Options arrow thingie at the end of the toolbar. Select
Add or Remove Buttons, select Drawing, then Select Multiple Objects. This
adds the Select Multiple Objects button. Click it and it will list all the
objects on the sheet. This helps you select the charts, then you can delete
them for good.

- Jon