+ Reply to Thread
Results 1 to 4 of 4

Moved Chart Doesnt appear in selection pane

  1. #1
    Forum Contributor
    Join Date
    01-08-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    100

    Moved Chart Doesnt appear in selection pane

    I created a chart on a sheet1 from data on sheet1
    I created a VBA Event Procedure that affects that chart
    I moved the chart to sheet2 using the "move chart" menu option

    Here's the problem...
    I moved the VBA event procedure to sheet2 and made the necessary adjustment to sheet and range references
    The procedure no longer works entirely correctly because Chart5 is not a ChartObject on sheet2
    I discovered that Chart5 does not appear in the Selection Pane as an object on sheet2.

    Does anyone know how to make the moved chart appear as a Chart Object in the destination sheet?
    Hopefully without recreating the chart as it was a PITA.

    Thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Moved Chart Doesnt appear in selection pane

    I think we need to see the workbook. It's not clear whether the chart is embedded in a sheet or whether it's a Chart sheet in its own right which seems to be the implication of your mention of Chart5.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    01-08-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    100

    Re: Moved Chart Doesnt appear in selection pane

    It is not part of its own Chart sheet.
    It was built as a part of sheet1 and moved to sheet2 using the "move chart" menu option.

    If I build a chart embedded in a worksheet it becomes an object on that sheet
    in this case it was automatically named Chart5 and was listed in the Selection Pane as Chart5.
    when I moved it to sheet2 it didn't appear in the Selection pane as an object in sheet2.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Moved Chart Doesnt appear in selection pane

    As I said I think we need to see the workbook so we may see the problem in context.

+ 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. Change Source Data for Chart Moved to a New Workbook
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2015, 04:03 AM
  2. Chart and Freeze Pane
    By tfromme in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-13-2015, 03:08 AM
  3. [SOLVED] Simplfiy macro for disable selection pane with "with"
    By DavidRoger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2014, 12:47 AM
  4. Data is in days and bar chart doesnt stack
    By simmo86 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-25-2009, 06:47 AM
  5. Combo Box doesn't drop down when chart in other pane is selected
    By rdfeigin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2007, 09:52 PM
  6. Moved data to new sheet based on list selection
    By scronk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2005, 04:05 AM
  7. [SOLVED] How do I automatically update chart source data links for moved fi
    By Suzuki7 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-15-2005, 12:06 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