Questions about my simple graph

[hbrems]

Hello,

I got a simple graph on my form based on the following query:

date | ordercount:
-------------------------
16/11/06 20
15/11/06 18
14/11/06 19
13/11/06 18
10/11/06 19
09/11/06 18

My graph is leaving out the TOP record and my datasheet I get this result:

16/11/06 | 20
-------------------------
15/11/06 18
14/11/06 19
13/11/06 18
10/11/06 19
09/11/06 18

So as you can see, my graph is actually confusing my TOP record with the title and that's why it's not showing. So how can I fix this?


On a sidenote:
As you can see, I didn't work on 11/11 & 12/11 but my graph is still showing those dates but of course with value 0. How can I leave out dates where I created no orders?

Kind regards,
B.

 

[Oldsoftboss]

On a sidenote:
As you can see, I didn't work on 11/11 & 12/11 but my graph is still showing those dates but of course with value 0. How can I leave out dates where I created no orders?

With Access graphs, I think it would be easier to work on those days

Dave

 

[The_Doc_Man]

Depending on the dialog you used to build the graph, you might run into an issue with the display of missing data. It depends on how you choose to display the graph.

If it is a bar chart, you can choose to make the data a CATEGORY and in that case, you might actually not absent days. If it is an X/Y scatter chart, you will display absent days as 0 because in that case, the date is a value, not a category. It's a fine point, admittedly, and I have yet to see a good explanation for why it works that way. Other than that like everything else, MS co-opted MS Graph from another source and retro-fitted it onto Access and Excel. Retro-fits are always ... touchy.

The issue with missing the TOP record is that somehow it thinks your top record is a title line. So .... give it one. Or try to right-click on the datasheet view to view the properties of same and see if there is a "First Row is Title" property. It has been a while since I played with this and I'll admit I'm awfully rusty with graphs.