+ Reply to Thread
Results 1 to 1 of 1

Advice needed for chart/table layout

  1. #1
    Registered User
    Join Date
    08-29-2019
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    6

    Advice needed for chart/table layout

    Before I throw my question out there, let me explain the situation.

    I work for a chicken farmer who has 3 barns with chickens. Every day the eggs have to be collected and sorted (good, weak or cracked, dirty, too heavy or too light). For each barn, the quantity and quality of the eggs have to be monitored, I chose to do that with Excel. My current layout looks like this, with the data shown per week number: (see attachment).

    The top row displays the week numbers, the rows below that are data types, like amount of good eggs, percentage of bad eggs, dirty eggs etc. The barns are color-coded. The button in the top-left corner is assigned a macro that gathers all the data per week. I would like a graph that automatically updates itself once data from a new week is added. I also want to compare certain data types, for example average daily production, egg quality and water intake of the chickens, between each barn. In the past I used the Name Manager to make dynamic ranges, but back then I only had 3 data types per barn, whereas I currently keep track of 10 data types per barn and that number is likely to increase in the future, which makes defining the dynamic ranges rather burdensome.

    So I would like some advice/tips on how to do this. Any ideas/suggestions are welcome. NB: The Excel file is in Dutch, but that shouldn't be a huge problem.
    Attached Images Attached Images
    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)

Similar Threads

  1. Pivot chart+table unsure how to layout and get to do what i need
    By Godssent2 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-22-2019, 10:44 PM
  2. Chart Layout in Excel - Help Needed!
    By Ascari in forum Excel General
    Replies: 6
    Last Post: 11-25-2014, 09:35 AM
  3. Layout advice
    By namluke in forum Excel General
    Replies: 3
    Last Post: 06-14-2014, 09:30 AM
  4. Organizing Data Table in a Bar Chart Layout 5
    By dco223 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-03-2014, 09:57 AM
  5. need advice for this skill chart table please
    By graveltrap in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 05-10-2010, 11:13 AM
  6. Advice on form layout.
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-16-2008, 11:29 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