Column Chart Y-axis Values Not Rendering

I'm trying to create a column chart and am having trouble with the y-axis values. I want to chart sales dollars by month, with the dollars on the y-axis.

The datasource is a datatable object with 2 columns, Month & Amount. I dragged the Month column into the category area, and the Amount column into the data fields area

The resulting chart shows a column for each month, but all months have a value of '1' rather than the actual values in the table. For testing, I dropped a table control on the page and the amount values show correctly (=Fields!Amount.Value).

Is the chart showing a count, perhaps? Any help is appreciated.

Maybe the Amount value is a formatted string, rather than a numeric value?

Try the following expression for the data point value in the chart: =Sum(CDbl(Fields!Amount.Value))

-- Robert

|||Thanks, Robert. That was it.