I am currently trying ot create a line chart using the monthly spend profile of many projects in excel. I would like the line chart to total the monthly profile spend into the projects relevant group and display this as a line over the 12 months..
Is this possile? I have attached some sample data if anyone can help me out.
I'm pretty sure it can be done. But your specifications are not quite clear to me. You excel file doesn't contain a field Spend for example, only Budget and Forecast. See attached qvw for an example.
