Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / August 2006

Tip: Looking for answers? Try searching our database.

line appears when deleting chart- cannot delete it

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian - 19 Aug 2006 22:04 GMT
I have deleted a number of entire rows that contained a chart. The chart has
been deleted but a line still appears that I cannot get rid of. If I delete a
chart by clicking on the chart and deleting it this line does not appear. Is
there a way to get ride of the line now?
S S - 20 Aug 2006 06:23 GMT
Not quite sure what you mean, but with my limited knowledge of excel could
it be that you have put a border around the chart and the edges of the
border are still in the undeleted rows.  Try Format/cells/Border.

>I have deleted a number of entire rows that contained a chart. The chart
>has
[quoted text clipped - 3 lines]
> Is
> there a way to get ride of the line now?
Debra Dalgleish - 20 Aug 2006 13:46 GMT
When you deleted all the rows behind them, the charts aren't deleted,
but shrink to a line in height. If there are not other objects on the
sheet that you want to keep, you can delete all the objects:

Choose Edit>Go to, and click Special
Select Objects, and click OK
Press the Delete key, to delete the selected objects

To work with specific objects, you can add the 'Select Multiple Objects'
tool to one of your toolbars:

Choose Tools>Customize
Select the Commands tab
Select the Drawing Category
Drag the 'Select Multiple Objects' tool onto one of your toolbars
Click Close

Then, click the Select Multiple Objects button, and select any or all
objects on the worksheet.

> I have deleted a number of entire rows that contained a chart. The chart has
> been deleted but a line still appears that I cannot get rid of. If I delete a
> chart by clicking on the chart and deleting it this line does not appear. Is
> there a way to get ride of the line now?

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.