LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 747
Default Deleting this white line?

The example white line is in fact a collapsed embedded chart. Perhaps the
columns containing the charts in your workbook were deleted and the charts
shrunk to zero width.

To delete them, I suggest placing the Select Multiple Objects icon on the
Worksheet Menu Bar (main tool bar):
1. Select ToolsCustomize from the Worksheet Menu Bar
2. Select the Command tab from the dialog that appears
3. Select Drawing from the Categories window
4. In the Commands window, left click the Select Multiple Objects icon
(typically 3rd from the top) and drag the icon onto the Worksheet Menu Bar
5. Close the Cusomize dialog
6. Now click the Select Multiple Objects icon. If I am correct, you will
see a chart or charts listed in the dialog that pops up
7. Click the chart(s) you want to delete (checkmarks will appear)
8. Click the OK button to close the dialog (this will select the charts)
9. Now click the Delete key

Note that you can instead drag to the right the sizing handle of one of the
selected charts to resize it so that it can be seen. FYI, the chart in your
example has a Y-axis title "Avg Repair Cost" and a legend with series names
"Labor", "Parts", "Handling", etc.

Regards,
Greg



"Ozz" wrote:

I am working on a report that has been made by other people in my department.
On almost every sheet I see white lines which I can't seem to delete.
The only way I know is to delete the entire rows.
No one knows how those lines are made.

I put an example of the line in a file at http://www.tazlure.nl/whiteline.xls

Can anyone tell me how this line can be deleted?
Thanks.



 
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
Keep formual intact after deleting a line vacation Excel Worksheet Functions 1 March 3rd 06 08:12 PM
Line Chart Aurora Charts and Charting in Excel 3 February 16th 06 11:24 PM
10 000 Line, every 2 Lines need a border and a open line inbet. e. annalie Excel Discussion (Misc queries) 2 January 30th 06 03:15 PM
A 2 line text showing up in the Cell in Excel prints in 1 line Danny Excel Discussion (Misc queries) 6 July 12th 05 08:47 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 08: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"