+ Reply to Thread
Results 1 to 3 of 3

Plot gaps when cells are empty

  1. #1
    Registered User
    Join Date
    08-28-2013
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    3

    Plot gaps when cells are empty

    Hi
    I need to plot gaps (not zeros or any othe value) on charts when cells are empty.
    The values of the cells are results of GETPIVOTDAT functions, where i use a condition to empty the cell instead of filling with zero.
    The formula is like this one:
    =IF(ISBLANK(GETPIVOTDATA("#ccts";'Pivot_90%'!$A$3;"SLA_TIPO";"TIPO2";"tipo_circuitos.Tipo";"Carro";"Ano_Mes_Pronto";$B5));"";GETPIVOTDATA("#ccts";'Pivot_90%'!$A$3;"SLA_TIPO";"TIPO2";"tipo_circuitos.Tipo";"Carro";"Ano_Mes_Pronto";$B5))

    I have a mix of charts types, line and bar, and any of them can have empty values
    Thanks

  2. #2
    Registered User
    Join Date
    08-28-2013
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Plot gaps when cells are empty

    No one cane help ?

  3. #3
    Registered User
    Join Date
    08-28-2013
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Plot gaps when cells are empty

    Hi, it seems there is no solution, I have been searching on the net and also here there is no answer.

    The main problem is there any way to "force" a cell to a null value when you have there a formula ?

+ 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. Excel 2010 - X Y scatter plot will not plot empty cells as gap
    By bjeffers0306 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2013, 12:56 AM
  2. Excel 2007 : Scatter plot with data gaps
    By Travis_OSS in forum Excel General
    Replies: 2
    Last Post: 04-08-2011, 09:03 AM
  3. plot data gaps
    By collins848484 in forum Excel General
    Replies: 6
    Last Post: 03-30-2011, 05:08 AM
  4. plot empty cells as interpolated
    By roly in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 04-23-2007, 07:06 PM
  5. Plot empty cells as: Interpolated
    By Jaco in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-14-2005, 09:05 AM

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