Blue Dot appears at top left of all graphs

Apparently they are shapes on the chartobjects. If you hover over them they are named "Oval 80", "Oval 79", etc. There are about 80 per chart, but I have no idea why they exist. As for removing them, try the code below on a copy of your workbook (to make sure it doesn't negatively impact anything else).

Most of this came from the example code at bottom of this Microsoft VBA Object Model reference page: https://docs.microsoft.com/en-us/off...l.shapes.range

Please Login or Register  to view this content.

To more specifically target just the "Oval" shapes, you could probably add that test to the line If .Item(i).Type = msoAutoShape Then, e.g. If .Item(i).Type = msoAutoShape and Left(.Item(i).Name, 4) = "Oval" Then

Update:

This code worked for ppt:

Please Login or Register  to view this content.

sakebomber...

Hi.

It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. This helps prevent massive confusion arising - which will happen if it is not clear which question is being answered. So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!


The yellow banner about sample worksheets, at the top of the screen tells you how to post a sheet here on the Forum.