Budgeting and Planning

You are here: Home : Topics A-Z : Budgeting and Planning

Add a New Month's Data to Existing Chart

Three easy methods to update trend data without recreating the whole chart.

September 8, 2010

Your department probably is responsible for producing a dozen or so monthly trend charts every month. These charts end up getting sent to an executive dashboard or tacked up on a bulletin board on the shop floor. Each month, one of your company analysts collects data for the month that just ended, then re-creates the charts. This process usually takes the better part of a morning in Excel. Read more...

Follow this topic

Sign up for newsletters
Subscribe to our Budgeting and Planning RSS feed

More Budgeting and Planning Articles

Show Me the Recovery
While second-quarter sales increases are encouraging, weak cash generation is worrisome. September 3, 2010
CFOs See 12% Capex Rise, Deloitte Survey Finds
Anemic payroll outlays and surging sales will fuel the growth in capital spending, the firm suggests. July 15, 2010
Equipment Leasing: No News Is Good News
While the Greek debt crisis may have spooked potential machinery buyers, forecasts of cheap capital may have made them picky. July 1, 2010
Free Cash Flow: At the Brink?
Up until now, companies have been able to find extra cash by cutting costs and capital spending. But if revenues stay flat, margins might narrow drastically. June 21, 2010
To Cut Working Capital, Try Bonuses
Pay incentives for hitting working capital targets proved effective during the recession, although companies are already starting to scale them back. June 3, 2010
Leases Headed for the Balance Sheet
The upcoming joint FASB/IASB exposure draft on lease accounting will put an end to off-balance-sheet treatment for leases, while throwing in some new complications. May 27, 2010
Double Trouble? Maybe Not
Companies that face simultaneous audits find that it pays to be diplomatic. May 1, 2010
Wait 'Til Next Year for Credit, Suppliers Say
Although more companies are collecting bills on time, a true strengthening of credit risk depends on an upsurge in consumer demand. December 14, 2009
Benchmarking Credit Risk: Cash Is the Key
Compared with the same period last year, fewer midcap companies were slow to pay their bills in the third quarter of 2009. December 9, 2009