Scatter Chart

[Georgi]

Good evening everybody,



As usual no problem with excel always having a critical problem with access,

I have built a scatter chart with excel and I was trying to build it in access as well but I failed, 08 working hours trying to sort it out, again please help.

Kindly see attached Excel and Access samples,

Thank you in advance.

[June7]

What I accomplished:

Added another field to the table, called Item, entered value of 1 for all records.

Created a new graph with wizard, let it create a bar chart with one series (Item field).

The chart RowSource query it created is:
TRANSFORM Sum([Inspection Rate]) AS [SumOfInspection Rate] SELECT [Maintenance Rate] FROM [tbl - Maintenance And Inspection Rate] GROUP BY [Maintenance Rate] PIVOT [Item];

Changed the chart to an XY Scatter.

Then I changed the RowSource to:
SELECT [Inspection Rate], [Maintenance Rate] FROM [tbl - Maintenance And Inspection Rate];

Removed the legend, resized chart area, other formatting as desired.

Opened report in Layout View, saved, closed, opened in design view and new settings are displayed.

I know, roundabout way but seems to get it done.

[Georgi]

Well done, thank you June appreciate it works 100%, I basically tried to resolve it by myself I failed, however the scatter chart works properly now.

Thank you and have a good day,