+ Reply to Thread
Results 1 to 4 of 4

Show in graphically or otherwise for progress for large data

  1. #1
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    305

    Show in graphically or otherwise for progress for large data

    Hi Expert,
    I have been asked my boss how each item sale is progressing ( over 500 of them) that are sold Jan to Nov .
    Attached file has few items. Each item are in large $ value and just looking at them as they are does not make any sense.
    I have no clue how to show using graphically ( not sure if possible)

    Each item is individual cannot be compared to others item.

    How do I show progress at glance?

    Any helpful suggestion or guidance is welcome
    Thanks in advance
    Karnik
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,926

    Re: Show in graphically or otherwise for progress for large data

    What is wrong with a simple line chart? or are you looking for something else? The attached could be improved a bit using named dynamic ranges to provide a rolling 12 month period.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    305

    Re: Show in graphically or otherwise for progress for large data

    Hi Dflak,
    Thanks for offering simple solution to pick up dynamic ranges. Request any more suggestions for enhancement,
    Thanks once again!
    Karnik

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,926

    Re: Show in graphically or otherwise for progress for large data

    If you need help with named dynamic ranges, see this wiki: http://www.utteraccess.com/wiki/inde...Dynamic_Ranges

+ 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. [SOLVED] How to show summay sheet with large volume of data
    By jimd1768 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-04-2015, 09:55 AM
  2. Better way to present data graphically
    By shaz0503 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-07-2015, 07:33 PM
  3. Replies: 3
    Last Post: 11-01-2012, 08:15 PM
  4. [SOLVED] How to show a ratio (13:1) graphically
    By mebirkle in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-24-2012, 01:05 PM
  5. Progress Bar + Show then hide
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2009, 11:16 AM
  6. How do I import large .csv file row by row with progress bar?
    By vwgolfman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2007, 05:34 PM
  7. I am trying to show graphically employees working 8:30 am to 6:00
    By mikiebigm in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-23-2006, 10:10 PM

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