Access Graph - Why does the PointsCollection only have 1 point when there are 2

[darbid]

I have attached an mdb as an example. Have a look at form 2. It is a graph (my attempt at a timeline) with only 2 points with the same date. The problem is if you click the button it will tell you how many points are in the points SeriesCollection - it says 1. But there should be two. The graph is based on table 3 where there are two records but have the same date.


If you want to see what the hell I am trying to do (a full blown example) see form 4 which is based on the other table.

 

[boblarson]

The problem is that your rowsource for the graph (and therefore the point count) is grouping on date and you only wind up with one record that way.

 

[darbid]

Of course. I was getting really frustrated with this because I was testing it in Excel and in excel I was getting 2 points and in Access only 1.

I was not thinking about what could be different and of course the ROWSOURCE is the difference.

would it be stretching the Forum Friendship too much to assist with the rowsource?

SELECT (Format([tl_date],"DDDDD")),Sum([tl_nm]) AS [SumOftl_nm] FROM [Table3]   GROUP BY (Int([tl_date])),(Format([tl_date],"DDDDD"));

What should I do with it?

Also / or in the alternative have you seen any good tutorials on creating the queries for Graph row sources?

 

[boblarson]

I think, if you want BOTH of the data points you will need to add in the tl_Status field somewhere in there.

 

[darbid]

I think, if you want BOTH of the data points you will need to add in the tl_Status field somewhere in there.

I was hoping for a little bit of spoon feeding in this case .

I am not sure that you can add the tl_Status in there other than as a series, but then I would have a series for each different status.

On another point - This "Timeline" idea is not that popular in this forum. What do people use to show events or milestones over time? For me I naturally draw something like this.

Should I put a copy of this into the sample MDBs?

 

[boblarson]

Okay, here's a copy of your database with the revised query underlying the graph on form2. It now shows 2 points. I don't know for 100% certainty that this is exactly what is needed.

 

[darbid]

Thank you bob.

And do you find this kind of chart "normal"? Theoretically what is normal or would you use?

 

[boblarson]

Personally, I haven't done much charting in the past 4 years, so I don't have much to go on here. And, the last charting I did was in Crystal Reports and not in Access.