Chart budget vs actual
Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on.
All I want to is to create a line-type chart for my dashboard where I can see the comparison between the budget and actual numbers for every month, instead of seeing this for every line or account. So, one graph where x axis is months and y axis is amounts, one line is showing budget and other line is showing actuals. I have not found a way to do so, because reports don´t let me select the columns I want to use for the graph; budget columns are separated, actual columns and variance columns separated as well.
thanks for any help.