Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default line appears when deleting chart- cannot delete it

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 EditGo 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 ToolsCustomize
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.



Brian wrote:
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?



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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line Chart Aurora Charts and Charting in Excel 1 March 8th 06 09:27 PM
Creating a line chart with two X-axes!! JaVaughn Excel Discussion (Misc queries) 1 June 30th 05 01:36 PM
Line chart in Excel - trendline incomplete [email protected] Charts and Charting in Excel 7 May 13th 05 01:21 PM
Chart Label wraps on the same line. "Wavelenght [nm]" appears as. rog Charts and Charting in Excel 1 December 15th 04 08:10 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"