+ Reply to Thread
Results 1 to 2 of 2

Is chart empty

  1. #1
    Registered User
    Join Date
    05-29-2012
    Location
    Dallas,Texas
    MS-Off Ver
    Excel 2010
    Posts
    58

    Is chart empty

    Hi,
    Is there any way to get a response if a chart is empty?
    If the chart is empty it sends back 0 and if it has values some value other than 0?
    In VB of course

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Is chart empty

    In VB of course
    Might need to feed us some more information here. Without knowing your particular's, the first thought that jumps out, check cell B2.

    If B2 is empty, possibly the chart is empty. Of course this would be adjusted for where you chart data exists. I'm assuming the data would be A1:B25 for example.
    HTH
    Regards, Jeff

+ 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. How to remove empty columns from the chart?
    By bagwell351 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 10-21-2017, 06:36 PM
  2. [SOLVED] empty chart after macro
    By Chris2250 in forum Excel Charting & Pivots
    Replies: 17
    Last Post: 05-19-2016, 04:31 AM
  3. Empty cells not in chart
    By NLatuny in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-07-2016, 06:33 AM
  4. Check if Chart data is empty
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2016, 12:18 PM
  5. Skipping empty fields in chart
    By pelachrum in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-20-2014, 06:05 PM
  6. ommitting empty cell from chart
    By douglukas in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-05-2008, 05:41 PM
  7. Empty Pivot Chart
    By Tony in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2005, 01:06 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