+ Reply to Thread
Results 1 to 3 of 3

Text boxes disappearing in the chart when closing and opening the file

  1. #1
    Registered User
    Join Date
    05-18-2022
    Location
    Ljubljana
    MS-Off Ver
    2016
    Posts
    16

    Text boxes disappearing in the chart when closing and opening the file

    I have a long set of charts that I prepare for publications (I work as a desktop publisher). The problem that I have is that after preparing a chart, saving and closing it, I frequently need to reopen it. Every time I do that the text box in the title disappears and I have to create a new one (for some special in-house reason the title needs to be a text box, not a chart element). Please see the attached image.

    I waste a lot of my time fixing this, because we're talking about 30 or more charts. There is no rule where it happens, with some charts it does, with some charts it doesn't. One solution would be creating a macro that would put back the text box, but of course I would prefer not losing the text box at all.

    Regards,
    Robert
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: Text boxes disappearing in the chart when closing and opening the file

    Are you still using Excel 2010? Please provide a small sample workbook that displays the problem.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    05-18-2022
    Location
    Ljubljana
    MS-Off Ver
    2016
    Posts
    16

    Re: Text boxes disappearing in the chart when closing and opening the file

    I use Excel 2016.
    Please find attached a simple workbook. Chart2 is the correct sheet.
    Thank you.
    Attached Files Attached Files

+ 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. Msgbox after closing the current file & opening the new file by vba
    By dumdumbum in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-17-2020, 07:23 AM
  2. Lossing Chart Boxes/ Text boxes when close file
    By david2003 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-05-2014, 09:39 AM
  3. Opening and closing a file in VB
    By tleaton in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2011, 07:49 PM
  4. Values in combo boxes not visible after closing then re-opening...
    By blankcomboboxes in forum Excel General
    Replies: 0
    Last Post: 04-26-2006, 02:25 PM
  5. Text Boxes Disappearing
    By Jordan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2005, 02:10 PM
  6. [SOLVED] Opening/Closing workbooks without dialog boxes
    By Steve :) in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2005, 05:05 PM
  7. [SOLVED] [SOLVED] Disappearing Text Boxes
    By [email protected] in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-04-2005, 10:06 PM

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