group, total, chart by fiscal years & months?

[jr]

i'm able to create a report that can group by month and year with totals
along the way. this works fine for calendar years, but how about with a
fiscal year starting may 1 of every year?

we'd also like a line or column chart that tracks a value month by month,
starting with may of the first year and ending april three years later. i
was able to pull the data up in excel using a pivot table, but when you
group that by month, it skips those without values, making the resulting
chart meaningless as we need to see the months with no new projects.

if it helps in answering: it's a database of projects, several clients,
each client has it's own set of tables, most reports are specific to a
particular client, but others include all. there may be months without any
new projects and others with many. fiscal year is may to april

many thanks.