+ Reply to Thread
Results 1 to 5 of 5

Plot where blank fields are ignored, not displayed.

  1. #1
    Registered User
    Join Date
    06-28-2011
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010, Excel 2011 for mac
    Posts
    82

    Plot where blank fields are ignored, not displayed.

    Hi!

    I have an excel file where some raw data is used for some calculations and the results are used in a plot.
    The raw data pasted into the sheet will have anywhere between 1000-8000 rows of data.

    I've made a worked example to show the code that I've done so far. If the data sheet doesn't contain data, i.e. only some of the rows are not empty, then the cell should be empty. This part works fine.

    However, when I plot the data, I only want to show the non-blank cells in the graph. Right now a blank cell ("") is considered as having the value zero. (Row 28-31 in the example)

    Is there anyway to let excel know that if the cells are blank then don't plot the cells?

    regards,
    kbka
    Attached Files Attached Files

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

    Re: Plot where blank fields are ignored, not displayed.

    What you need is probably dynamic named ranges for charts. See if this helps

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

  3. #3
    Registered User
    Join Date
    06-28-2011
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010, Excel 2011 for mac
    Posts
    82

    Re: Plot where blank fields are ignored, not displayed.

    This did the trick! thanks a bunch!
    Last edited by Cutter; 07-17-2012 at 10:57 AM. Reason: Removed whole post quote

  4. #4
    Registered User
    Join Date
    06-28-2011
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010, Excel 2011 for mac
    Posts
    82

    Re: Plot where blank fields are ignored, not displayed.

    I have an issue now with the Horizontal (category) Axis labels. It shows only the standard numbering. If I choose the label range (date format) it shows only the first label.

    I tried naming the label range just like the data ranges using the offset function but this doesn't seem to work either.

    any suggestions?

  5. #5
    Registered User
    Join Date
    06-28-2011
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010, Excel 2011 for mac
    Posts
    82

    Re: Plot where blank fields are ignored, not displayed.

    Quote Originally Posted by kbka View Post
    I have an issue now with the Horizontal (category) Axis labels. It shows only the standard numbering. If I choose the label range (date format) it shows only the first label.

    I tried naming the label range just like the data ranges using the offset function but this doesn't seem to work either.

    any suggestions?
    Worked by naming the label range again. Must hvae done something wrong

+ 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