+ Reply to Thread
Results 1 to 3 of 3

Inhibiting chart graphing for future data

  1. #1
    Registered User
    Join Date
    07-13-2012
    Location
    Mass, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Inhibiting chart graphing for future data

    I manage charting for production where we have tables of Planned output (qty), Actual output, Variance and Yield for many types of products across all 13 weeks of every quarter. The Planned qty is for the entire quarter from the start. Obviously the Actuals, Variance and Yield are valid for the week they are entered. The Variance is the calculated difference in the tables and Yield is another calculated value in the tables

    The goal is to limit the data entry person to entering the quarter# and week# they are entering the data for, and entering all the Actuals and Yield data for all various products one week at a time.

    I need to leave all the production calculations (Variance, Yield, and accrued week-to-week output) in the tables for all weeks, otherwise I need to either 1) massage the tables by dragging the calculations into the present week, or 2) massage the selected data array for the graph charts to limit the graphs to the past and present Actuals, Variance and Yield.

    How can I either automate the tables to not use future calculations which result in displaying irrelevant future graphs (another way of saying this is to use only the past and present data), or automate the selected data of the graphs to display only the past and present values?

    The charts are used for reporting.

    [I hope this makes sense]

    Thanks,

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,114

    Re: Inhibiting chart graphing for future data

    Search the forum for Dynamic named ranges.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Inhibiting chart graphing for future data

    This might help..

    http://www.excelforum.com/excel-char...html?p=2850579
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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