+ Reply to Thread
Results 1 to 5 of 5

Am I trying to put too much data into a chart - what are alternatives?

Hybrid View

  1. #1
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Am I trying to put too much data into a chart - what are alternatives?

    Heat map may help as initial step.

    Though not suitable when date range becomes much larger than current one.
    0.JPG


    Same as MrShorty, I hate 3d charts, it really adds nothing to insight and is just a visual fluff. There's more detriment than benefit to using 3d chart in my opinion.

    Typically I'd use PowerPivot to summarize and analyze data (especially where time intelligence is involved).

    Here's quick way to slice through data using various time frame using regular pivottable.
    By week and Day of week as an example. Currently showing avg. weighed out.

    You could have multiple pivottable/chart linked via slicer to show info in multiple charts, without overclouding single chart.

    Max value for x-axis (value axis) is set to 4000.00 to keep consistent scale of bars across different slice.
    NOTE: Probably should set to 5500 or whatever will be slightly larger than max value.
    Attached Files Attached Files
    Last edited by CK76; 01-23-2018 at 02:31 PM.
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

  2. #2
    Registered User
    Join Date
    05-25-2016
    Location
    Hollywood, CA
    MS-Off Ver
    2016
    Posts
    79

    Re: Am I trying to put too much data into a chart - what are alternatives?

    Fantastic! Is is possible to have the day and date appear on the pivot chart as slicer buttons are changed?

+ 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. Alternatives to Vlookup.
    By andresndor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2017, 03:04 PM
  2. Looking For Alternatives to VBA/Maccro to AUTOMATE Data Entry
    By 777merlin777 in forum Excel General
    Replies: 21
    Last Post: 04-26-2017, 10:13 AM
  3. Replies: 1
    Last Post: 04-22-2016, 10:44 AM
  4. Alternatives to Data Validation on a Shared Workbook
    By stevenoob in forum Excel General
    Replies: 0
    Last Post: 07-11-2013, 03:20 AM
  5. ADO too slow, any alternatives?
    By CrashAlpha in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2013, 08:52 PM
  6. Replies: 9
    Last Post: 01-29-2013, 10:36 PM
  7. What are the alternatives ???
    By christopherp in forum Excel General
    Replies: 4
    Last Post: 03-19-2006, 10:39 AM

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