+ Reply to Thread
Results 1 to 2 of 2

charts are disappearing upon scrolling

  1. #1
    Registered User
    Join Date
    07-27-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007,2010, 2013
    Posts
    26

    charts are disappearing upon scrolling

    Dear all,

    I am trying to create a summary spread sheet for several data. On this spread sheet I am placing tables and charts underneath.
    The number of pages on this sheet is mounting upto 50 pages.
    After pasting charts from different workbooks into this spreadsheet, some charts disappears completely, others have only the frame of the chart showing, and all charts drift and change location or appear in a different place than where it was placed.

    If I put on print preview, I can see all charts, but still dislocated and they disappear when I switch to normal mode.

    Many Thanks in advance.
    M.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,077

    Re: charts are disappearing upon scrolling

    After pasting a chart, right click on the chart then select "Format Chart Area", "Properties". Select the radio button to set "Don't move or size with cells". You can now place and size the chart exactly as you need to.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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. Disappearing charts when moving from 2003 to 2010
    By Bokito in forum Excel General
    Replies: 0
    Last Post: 03-23-2012, 04:49 AM
  2. charts disappearing, then changed
    By Boilermaker19 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-20-2011, 01:18 PM
  3. Scrolling Charts
    By mangeshp4 in forum Excel General
    Replies: 5
    Last Post: 01-28-2011, 07:29 AM
  4. Scroll Bars Scrolling Multiple Charts
    By Mordred in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-30-2010, 09:27 AM
  5. Disappearing/Greyed Charts
    By Absurd Jewel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-22-2006, 10:10 AM
  6. Disappearing charts
    By Dave G in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2006, 08:50 PM
  7. [SOLVED] Charts and Graphs disappearing
    By Christine in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-17-2006, 06:20 PM
  8. [SOLVED] Disappearing scales on bar charts with multiple series
    By Patrick in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-03-2005, 05:15 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