Please add a sheet not a picture - Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer,

Sorry for the misunderstanding.

I've attached the workbook as there's nothing sensitive or personal about it.

The previously attached screen shots of the graphs might help as they show how the graph should look.

Thanks again

Ady

Oh, forgot to mention, this version was created and saved as an Office97-2003 .xls version as I tried re-creating it at work with their older version of Office instead of my 2007 .xlsx version but the result was the same. Thanks

Attached Files

Eades - Peak Flow Diary (with formulas).xls (149.5 KB, 12 views)

I have discovered that the problem is not with the lookup part of the formula itself, its a problem with the part of the formula that allow for the facility to only display data if it exits.

It doesn't like 'IF' no data exists, display "" (empty cell). If I repace it with 'IF no data exists, display 0, the data is displayed correctly on the graph.

This isn't ideal but it's progress!

I've attached a trail sheet to show what I'm talking about. Hope it helps!

Thanks

Attached Files

Book1.xls (30.5 KB, 11 views)