• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Creating line chart gaps with formulas

    Thank you both for your answers. Faseeh- if I understand correctly, your solution is to replace the error with a different error? If so, as I already decribed above- anything that is not "truly blank" (a go to cell and press delete kind of blank) will chart. Some errors chart as zero, others...
  2. J

    Excel Formula

    A=HLOOKUP(A$6,$A$1:$D$4,2;0) B=HLOOKUP(A$6,$A$1:$D$4,3;0) C=HLOOKUP(A$6,$A$1:$D$4,4;0) Adjust the range of your data and lookup value and copy accros rows. For the dates missing it will return error. If you want to avoid that use this formula A=IFERROR(HLOOKUP(B$6,$A$1:$D$4,2,0),"") it...
  3. J

    Creating line chart gaps with formulas

    Hi, I have a line chart that charts 35 cases. The source data for this chart is created from formulas, that lookup the data in a larger dataset. The formulas are necessary because the chart is dynamic and the range changes upon user interaction. Here is my problem: In my original dataset...
Back
Top