Graph data header row

  • Thread starter Thread starter NevilleT
  • Start date Start date
N

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.
 
Neville,

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

Jack Cannon
 
NevilleT said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How do I sum a column based on 2 different column headers/criteria? 0
Transferspreadsheet - insert rows with no header 1
Report Repeats Chart on Multiple Pages 1
How to Display the Graph Data Sheet View with Legend Colors 1
How do I find the record source of a graph ??? 1
Linking text files, ignoring header data 1
Access Sorting and grouping using multiple tables 0

Back
Top