+ Reply to Thread
Results 1 to 2 of 2

Dynamic Charts with formulas in "empty" cells (open to any type of solution)

  1. #1
    Registered User
    Join Date
    08-05-2014
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    1

    Dynamic Charts with formulas in "empty" cells (open to any type of solution)

    Hello guys,

    I've looked around the internet and couldn't find an answer that would fit my need so I come with a question.

    I'm in the process of trying to make a dynamic chart that updates every month. The way we have it set up is we have a Data Input tab where all the numbers go, and that will populate multiple other tabs within the sheet. For every column, there's a different month, and I'd like to have it populate only when there is a non $0 number (or at certain date like middle of the month) in an automated way. I'm going to be passing this on to some other people that really aren't Excel savy at all, so just changing some ranges on the graphs can be difficult for them.

    Currently what I have right now is Chart 1 (on the Excel sheet: Charts), but that includes dates up to December 2015 with half of it being 0... I would love to have something like Chart 2, that dynamically adds months whenever something that's > 0 is entered.

    Anyone have any idea?

    Thank you!
    Attached Files Attached Files

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

    Re: Dynamic Charts with formulas in "empty" cells (open to any type of solution)

    You can use named ranges to define data to be used in each series.

    Use Name Manager to see named formula I have set up.
    Use charts Select Data to see how the named formula have been used instead of fixed cell references.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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: 8
    Last Post: 07-06-2014, 08:51 PM
  2. [SOLVED] average formula without using cells that have "empty" formulas
    By kreckzin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-25-2012, 03:24 AM
  3. VBA. Fill empty cells with text "OPEN", I2 downwards, row count Col A
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-17-2011, 06:50 PM
  4. Replies: 4
    Last Post: 02-03-2008, 05:11 PM
  5. solution for "cannot empty the clipboard"
    By Bucky in forum Excel General
    Replies: 1
    Last Post: 09-13-2005, 08:05 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