Hi,
I am trying to create a chart like the one attached. I have 5 spreadsheets. Each contains: Funder and amount of funding. Each spreadhseet represents a year . I want the x axis to show year, y to show amount range, and the legend to show name of funder. then per year I want to show each funder stacked according to amount (funding).
Also, per spreadhseet I have funders that show up each year and then new ones. so it's not consistent.
Can you help?
I am trying to create a chart like the one attached. I have 5 spreadsheets. Each contains: Funder and amount of funding. Each spreadhseet represents a year . I want the x axis to show year, y to show amount range, and the legend to show name of funder. then per year I want to show each funder stacked according to amount (funding).
Also, per spreadhseet I have funders that show up each year and then new ones. so it's not consistent.
Can you help?
Attachments
Last edited: