Line Chart Newbie Questions

[RB85]

Hi All,

I have a line chart that is reading data from a query, its reading pressure levels [Elevation (m H2O)] at various times [RecordingsDateTime] from different locations [SensorName]. The recordings are usually twice a day but the line chart Axis (category) only appears to allow a minimum of daily data and therefore sums the two if on the same day. How can I change this to display each reading?

Is it also possible to have a dropdown menu to only select one series? The query contains all locations but I only want to view one location at a time.



Thanks,
RB

[RB85]

I've created a query linked to the dropdown box and now getting the values in the query I want to be display based on the combobox selection. However, when I try to plot this on the line chart it appears blank when I select a Legend (series).

Looking at the Transformed Row Source for the chart it says it doesnt recognise the combobox as a valid field name or expression when I try to the query. The query runs fine outside of the line chart. Any ideas how to fix?

[June7]

Need to provide SQL statement for analysis. And sample data would be helpful. Could provide db. Follow instructions at bottom of my post.

[RB85]

Attached the version I'm playing around with. Its the line chart on frmVWPChart I want to display similar to how it currently is but link to qrySensorSelected2 so it only displays sensors from the selected location in Combo46.

After that I'd like to be able to put date range limits on the x-axis, I assume this is best done by linking the query to two new date text boxes if I can get the query working in the line chart.

[June7]

Unfortunately, I cannot work with Modern Charts because I use Access 2010. The chart doesn't even appear for me.

So I tested with a classic MSGraph chart.

After making criteria selections, need to refresh chart. Can do this with the Refresh button on ribbon or VBA.

Exactly what are you entering into the chart RowSource property?

[isladogs]

If you look at the transform SQL in the chart data property sheet, you will see why it only shows readings for each day.
You need to edit the SQL statement that Access 'helpfully' created to show the date and time

[RB85]

Unfortunately, I cannot work with Modern Charts because I use Access 2010. The chart doesn't even appear for me.

So I tested with a classic MSGraph chart.

After making criteria selections, need to refresh chart. Can do this with the Refresh button on ribbon or VBA.

Exactly what are you entering into the chart RowSource property?

When I select the row source as qrySensorSelected2 and get the error mentioned above that it doesnt recognise Cpmbo46 as a valid field name or expression, the transformed row source Im using is:
TRANSFORM Max([Elevation (m H2O)]) AS [MaxOfElevation (m H2O)] SELECT Format([RecordingDateTime], "DDDDD") FROM [qrySensorSelected2] GROUP BY Format([RecordingDateTime], "DDDDD"), Int([RecordingDateTime]) ORDER BY Int([RecordingDateTime]) PIVOT [SensorName]

qrySensorSelected2 works fine as a query by itself just wont display the results on the chart.

[RB85]

Latest problem solved. I had to define the combo box parameter in the query.

[Welshgasman]

Latest problem solved. I had to define the combo box parameter in the query.

Please mark it solved then.