+ Reply to Thread
Results 1 to 1 of 1

Form control slider to adjust chart series crashes Excel 365

  1. #1
    Forum Contributor
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit
    Posts
    139

    Form control slider to adjust chart series crashes Excel 365

    Hi All,

    I have a scrollable chart which works well in earlier version of Excel but causes Excel 365 to crash.

    The file is a normal xlsx workbook with two worksheets.
    The first worksheet called "data" contains columns for a date and the number of vegetables used.
    These columns are used to create series in the chart worksheet.

    In the Name Manager, I have named ranges for each of these series which refers to an offset from B4. B4 is linked to a form control slider on the chart. The effect of this is that, using the slider, you can scroll the chart back and forth.
    There is also another slider which determines the pitch of the chart - how much data is displayed in one go.

    As mentioned, this works in earlier versions of Excel but moving either slider in 365 causes it to terminate itself without any error or warning.
    There is an application error entry in Event Viewer with:
    Exception code: 0xc0000005
    Fault offset: 0x003c4396



    I've attached a copy of the file and would appreciate any help.
    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)

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