Actually, I keep experimenting with this and it seems like I might need a separate table for Fiscal Year in order to show a chart this way? It keeps trying to give me a data set for every record in Projects rather than aggregating based on Fiscal Year. Is this the way to go...create a new table for Fiscal Year? Does it make sense to create a new table just to format a chart?
I don't see the need for any of that if you are charting summarized data and sort your records by Fiscal Year. This is kind of like charting a summary report where each point on your chart is somewhat analogous to a sub summary layout part.
This might work pretty well as a stacked bar chart.
The only reason that I'd see for a special table is if there are fiscal years with zero projects and you want the x-axis scale to show every year.
Phil, thanks so much! This was SO simple as I figured it should be. It never occurred to me to sort the data.