Graph data header row

[NevilleT]

I have a graph in a form. I use a query as the rowsource. Problem is it
ignores the first row as it thinks it is the header. I can go into the chart
and add a header row and the chart looks fine. Every time I open the form,
the header row is replaced and I am back to square one. Is there a way to
let the chart know there is no header row? I am sure I have worked around
this in the past but no idea how.

 

[Jack Cannon]

Neville,

You can get this reaction if Column Heads are set to "No" (Default).
Try setting the Column Heads to "Yes"

Jack Cannon

 

[LITTLEBITKEL]

I have a graph in a form. I use a query as the rowsource. Problem is it
ignores the first row as it thinks it is the header. I can go into the
chart
and add a header row and the chart looks fine. Every time I open the
form,
the header row is replaced and I am back to square one. Is there a way to
let the chart know there is no header row? I am sure I have worked around
this in the past but no idea how.

 

[NevilleT]

Thanks for that. Did the trick.