Simple Line Chart field result over time

[illicited]

I'm having trouble understanding how Access does its charts. I'm trying to create a simple line chart that plots the values of one field over time. Is there no way to do this? Access keeps trying to total and adds East/West/North for some silly reason and breaks things into quarters when I set it by day. I'm very confused with how it is generating these charts.

[June7]

Access charting does take some getting used to. I analyse graph issues best when I can work with data. If you want to provide db, follow instructions at bottom of my post.

[illicited]

All I'm looking to do is have dates appear on the x-axis and result on the y-axis the data would be these two columns in a query:

x-axis

sampleDate
1/16/2014
1/17/2014
1/13/2014
1/13/2014
1/15/2014
1/21/2014
6/11/2010
5/25/2010
10/3/2008

y-axis

Result
9.77
9.48
3.67
89.78
0.00
0.00
0.20
1.23
0.10

[June7]

Suggest you let the chart wizard create chart with whatever then modify it as needed. That's how I usually manage.

Try setting the chart RowSource property to:

SELECT sampledate, Result FROM tablename {where criteria here if needed};

Open report in Layout and/or Report view then save the report, close then open in design view. Should see your chart setup instead of the generic wizard settings. At least that's the only way I can get to take effect, although I might not have correctly remembered the sequence of open/close/open. It's trial and error every time I build a graph.

[illicited]

Ahh I didn't realize it put generic info in there.. that was very confusing. Once I went to layout mode it actually displayed as I wanted it to.