Thanks for the response.
But What I need is to be able to calculate and plot the difference in the budgeted values in segments over timeline( Quarterly)
For example, I want to calculate & Plot:
QuarterDiff1(Corporate-Consumer) = Budgeted value of Corporate segment (Q1,2010) - Budgeted value of Consumer segment (Q1,2010)
= 152986 - 93022
QuarterDiff2(Small Business- Home Office) = Budgeted value of Small Business (Q1,2010) - Budgeted value of Home Office (Q1,2010)
= 70818 - 99054
I want to plot "QuarterDiff1" ,"QuarterDiff2" on Rows, and Date on Column. in worksheet.
Thanks in advance.