Accounting

You are here: Home : Topics A-Z : Accounting

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 Accounting RSS feed

More Accounting Articles

Six Magic Clicks to Roll Up Daily Records
The grouping feature in Excel pivot table allows you to turn a large data set of daily records into a report showing year-over-year figures by month or quarter. September 2, 2010
Why the SEC Won't Flip the IFRS Switch
Risk analysis indicates that the SEC is highly unlikely to require public U.S. companies to use IFRS instead of U.S. GAAP if the two sets of standards remain substantially different. September 2, 2010
So Much for "Death by Committee"
Audit committees have expanded their scope, and new rules may force them to broaden it even further. September 1, 2010
Fees Still Falling, but Not as Dramatically
The latest analysis of audit fees shows continued good news for most companies, but not all. September 1, 2010
Cloudy Future for GAAP
Robert Herz's retirement and the need for FASB to replace him as well as add two new members will likely delay significant changes to U.S. accounting rules. August 31, 2010
Suit Based on U.S. GAAP Proceeds
Popular Inc. looses its plea to dismiss a class-action securities suit involving the alleged improper booking of deferred tax assets. August 30, 2010
And the Winner Is...
What CFOs can learn from Ernst & Young's secretive tabulating of the Emmy Award ballots. August 27, 2010
Finance Execs React to Herz's Retirement
The FASB chairman's startling announcement has CFOs concerned, but they aren't adjusting their plans for dealing with pending changes to accounting rules. August 26, 2010
IFRS North of the Border
Canadian companies offer a preview of what it's like to switch to international accounting standards as their January 1, 2011, adoption deadline nears. August 25, 2010