I am wondering if I can chart revenue by month in the below example?

bhayd

The chart is pulling from a cell that for instance is a $1M dollar project over multiple months however I can only figure out how to display the revenue in the 1 month.

=SUMIFS({Pipeline Overview Data Range 2}, {Pipeline Overview Data Range 5}, >=[Start Date]19, {Pipeline Overview Data Range 5}, <[End Date]19, {Pipeline Overview Data Range 3}, "Won") / 1000

bhayd

There may be a better way of doing this as well and I'm open to suggestions.

BullandKhmer

Show us the sheet/ report you are pulling from

bhayd

Range 2 - Amount

Range 5 - Revenue Month

Range 3 - Status

Paul Newcome

It should be working if you are using that same formula in each of the other date rows. Then when you select the data for the chart you would select multiple rows.

bhayd

Thanks for answering Paul. It does work like that if you want to record all revenue in the same month. If, however I want to see the revenue divided over the next 4 moths, I can't seem to figure that out.

Paul Newcome

You would have to use a helper column in the source sheet for that. Basically you would divide the total by the number of months then reference this new column in your SUMIFS.