+ Reply to Thread
Results 1 to 2 of 2

Chart Display to automatically update based on cells with values?

Hybrid View

MacroPolo Chart Display to... 08-21-2012, 01:49 PM
Ace_XL Re: Chart Display to... 08-21-2012, 04:44 PM
  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    63

    Chart Display to automatically update based on cells with values?

    Say I have a chart display Cells A1:A12 and B1:B12, for each month.

    Can I set the chart to display only the cells with values?


    For instance, in March, I would only want A1:A3 and B1:B3 displayed. In June, A1:A6 and B1:B6 displayed, and so on.


    Trying to avoid showing a bunch of zeros that will invalidate my trend line. Thanks guys!

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

    Re: Chart Display to automatically update based on cells with values?

    This might help you get started..

    http://www.excelforum.com/excel-char...el-2003-a.html
    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