+ Reply to Thread
Results 1 to 5 of 5

Blue Dot appears at top left of all graphs

  1. #1
    Registered User
    Join Date
    04-30-2020
    Location
    Chicago
    MS-Off Ver
    365
    Posts
    3

    Blue Dot appears at top left of all graphs

    Hi All,

    Getting this really annoying tiny blue dot that appears at the top left of all my graphs and charts. I can select it, but if I hit delete it stays there. If I move it around it duplicates itself, as if there is an infinite number of them stacked on each other. Does anyone know how to fix? Photo attached.

    Thanks!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,799

    Re: 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

  3. #3
    Registered User
    Join Date
    04-26-2020
    Location
    Massachusetts
    MS-Off Ver
    Office 365
    Posts
    68

    Re: Blue Dot appears at top left of all graphs

    If Paul did not solve your problem please show the data used to create the charts in the Excel file you have posted

  4. #4
    Registered User
    Join Date
    04-30-2020
    Location
    Chicago
    MS-Off Ver
    365
    Posts
    3

    Re: Blue Dot appears at top left of all graphs

    Thanks Paul for the code, it worked on Excel. Any idea how I can get it to work on ppt vba as well? Would save me a lot of time.

    Much appreciated!

  5. #5
    Registered User
    Join Date
    04-30-2020
    Location
    Chicago
    MS-Off Ver
    365
    Posts
    3

    Re: Blue Dot appears at top left of all graphs

    Update:

    This code worked for ppt:
    Please Login or Register  to view this content.
    Last edited by Paul; 05-01-2020 at 12:58 PM. Reason: Added CODE tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] separate the starting digit of each number and add the amount in the blue matrix the blue
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2019, 05:41 PM
  2. Replies: 6
    Last Post: 01-30-2018, 12:37 PM
  3. [SOLVED] Need A Macro To Remove All Data Except The Red & Blue Data On The Left Side To Right Side
    By Daddy007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2016, 12:30 PM
  4. Conditional Format to Blue Fill and Blue Font IF two conditions are met
    By Branbran10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2015, 10:52 AM
  5. ''navigation pane'' appears on the left at startup
    By Joe Miller in forum Excel General
    Replies: 1
    Last Post: 11-05-2014, 10:51 AM
  6. Turn cell A1 blue if any cells between $L$6:$Q$9 are blue
    By sandk0330 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2013, 02:53 PM
  7. Count number of cells that contain red, blue or red and blue
    By kjshearon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-17-2013, 11:26 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1