X/Y Scatter Chart

[hehrerh]

Per the attached image, when I set up a x/y scatter chart through the wizard, the chart shows up just fine.

However, when I open in report view, it converts what should be 1 line covering 12 data points into 12 dines covering 1 data point.

The data seems to be arranged correctly in the underlying query.. do I need to transpose the data to get it to look right? If so, how?

Thanks!

[isladogs]

You've tried to squeeze in too many things into your screenshot so it isn't clear
Suggest you crop and upload 2 images - design view and print preview.
Also provide the SQL record source for your chart - it is impossible to do more than guess with what you've provided so far

[June7]

In form Design view, double click on the graph and then on the graph edit menu, try clicking the ByColumn icon.

[hehrerh]

SELECT B_00All.[SaleMonth], Sum(B_00All.[SalePrice]) AS SumOfSalePrice
FROM B_00All
GROUP BY B_00All.[SaleMonth];

[hehrerh]

This did it! Thanks