+ Reply to Thread
Results 1 to 1 of 1

Max number per chart is 255 - Ignore dialog box or select multiple slicer before plotting

  1. #1
    Registered User
    Join Date
    06-17-2015
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2010
    Posts
    1

    Max number per chart is 255 - Ignore dialog box or select multiple slicer before plotting

    Hi Excel Experts!

    I am running Excel 2010.
    I have a raw data set consisting of about 31000 rows and 10 columns. In my columns, month, year, market, product, pack, company volume, sales etc.

    I have created a dashboard with 6 different charts connected to separate pivot tables, where the pivot tables are located in separate sheets. The dashboard is created with slicers (8) and the selection will provide the appropriate graphs.

    My problem occurs when i clear all my selections and or choose a specific market. One market contains more than 255 different products, and I get the dialog box: "maximum number of data series per chart is 255". The dialog box will pop up on my screen multiple times and I have to press "Ok" multiple times.

    I do not need the +255 plots showing at the same time, but in order for the dashboard to work, one will first have to click the "market" slicer and thereafter specify the appropriate products, packs, company etc.

    I have some suggestions what could be the solution, but unfortunately, I don't know to do it. I only need one solution of course, so no need to answer all the questions/if any,

    Is there any way I can prevent the dialog box from showing, simply disabling it or a macro auto-clicking it? - I know I cannot plot more than 255 data series per chart and I do not want to do this. The user simply has to select more criteria before the chart becomes useful.

    Is it possible to make a macro/tell Excel that there must be a minimum of for example 3 slicers chosen, before it plots the graph? - I do, however, need the slicers to be updated, so when the user selects the market, the appropriate products, packs & companies shows up. This should limit the data series per chart to less than 255

    One note: It has to work on another computer, when i forward the file.

    I am open to any suggestions, but wanted to give some of my ideas as well.

    I really hope someone can help me out, because I have been looking around for a long time for an answer, but have not been able to find one.

    Kind regards,
    Jacob
    Attached Files Attached Files
    Last edited by jacobardar; 08-16-2015 at 03:50 PM.

+ 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. Replies: 1
    Last Post: 06-01-2015, 12:37 AM
  2. [SOLVED] Plotting chart with multiple columns
    By theromex in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-02-2015, 01:58 PM
  3. Need help plotting multiple sets of data on same chart
    By sarkar.50 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-05-2014, 03:29 PM
  4. Newbie: Auto Select/un-Select an Range of Slicer Items
    By luckyali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 09:52 AM
  5. Select multiple values from an Excel table in a slicer using VBA
    By ecotm034 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2014, 07:28 AM
  6. Macro for plotting chart on Multiple sheets
    By mrigtrishna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2012, 06:02 AM
  7. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 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