+ Reply to Thread
Results 1 to 7 of 7

Graphs that skip data =0

Hybrid View

superchew Graphs that skip data =0 11-13-2014, 02:42 PM
Glenn Kennedy Re: Graphs that skip data =0 11-13-2014, 02:49 PM
superchew Re: Graphs that skip data =0 11-13-2014, 03:05 PM
superchew Re: Graphs that skip data =0 11-13-2014, 03:50 PM
martindwilson Re: Graphs that skip data =0 11-13-2014, 03:46 PM
Glenn Kennedy Re: Graphs that skip data =0 11-16-2014, 04:35 AM
superchew Re: Graphs that skip data =0 11-28-2014, 09:07 PM
  1. 11-13-2014, 03:46 PM #1
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Graphs that skip data =0

    you need to use a diferent column for your data series using that formula
    see attached
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. # of blank labels to skip
    By jdlc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2014, 03:36 PM
  2. Get External Data from Web - Batch request - skip if no data is retrieved from webpage
    By cooper.1651 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-18-2014, 12:44 PM
  3. Graphs - Formula in source data outputs "" to override errors - ruining graphs
    By davidx in forum Excel General
    Replies: 4
    Last Post: 07-15-2013, 05:42 AM
  4. Formula for avg skip, max skip, longest out
    By Jordans121 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2010, 04:56 PM
  5. CHange 15 minute data to hourly data or skip 3 cells in Excel
    By jdbaba in forum Excel General
    Replies: 1
    Last Post: 11-08-2010, 02:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1