I'd like to be able to make set of bar charts that summarizes a field in my table for the y-axis. For example, something like 'state' in the x-axis and the sum of acres by state in the y-axis. When I create a bar chart for the state field, the only options that I am given for the y-axis are Shape_Area and Shape_Length. What do I need to do to go more options on the y-axis? I'm happy to do some data manipulations, I just need to know what the best way to go about it would be.
Would it be possible to send a screenshot of the fields within your dataset?
So, what I would like to be able to do I create a bar chart that would show 'Great Plains on the x-axis, and the column would show 769.06 (the sum of the acres). Please let me know if there is any other screenshots you would like.
Is the {Acres} field type a Number? If so you should be able to drag to a Bar Chart and get the following.
It is a number. That was the issue though, in the table the field type for this column was 'Text' and not a numeric data type. I made a new field for this column that had a numeric data type and I was able to make the calculations that I wanted.