valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Item is 2058199
Questions & Answers
Q: Is it possible to have a sheet that graphs ONE LINE of the budget. There is a graph for the total (Actual and Budget Chart) - but I'd like to be able to produce the same graph for ANY line from the chart of accounts. This way we can see for a line item how we're doing.
A: This is not a possible from the standard compiler but you can open/save a new workbook and then link to the compiler data ie make the new workbook cells take data from the compiler so you end up with a formula like ='[New Budget.xlsm]Profit and Loss'!$M$16 . This allows you to set up any data links you like (ie line by line) and then plot as you like.
Question and Answer Item 2058199 - Browse All Question and Answer Items