Problem adding a data table to x/y scatter chart

[hehrerh]

I have an x/y scatter chart, but cannot access the 'data table' feature. I want to summarize the y data points in a table below the graph.

The data table button is gray (disabled), and I can't figure out why. I'm using an x/y scatter chart, and my data is fine.

The underlying query for the chart is pasted below. See attached screenshot for a picture of where the button is located in the chart editor.

Thank you,
Howie

SELECT (Format([SaleDate],"mmm"" '""yy")) AS Expr1, Sum(B_00DeveloperYear.SalePrice) AS Revenue, Sum(B_00DeveloperYear.NetCosts) AS Costs, Sum(B_00DeveloperYear.AdjGM) AS Margin
FROM B_00DeveloperYear
GROUP BY (Format([SaleDate],"mmm"" '""yy")), (Year([SaleDate])*12+Month([SaleDate])-1);

[ranman256]

you dont add tables to a chart.
you add a chart, the chart is connected to a table/query.

[isladogs]

you dont add tables to a chart.
you add a chart, the chart is connected to a table/query.

I think you misunderstood what the OP means. He wants to show the data table like below:



To do this, click on the chart to enter Edit mode then right click & select Chart Options
Click the data table tab and tick Show data Table