Advanced Excel Feature — Live Charts and Live Textboxes
Unlocking a Powerful Tool to enhance your work quality
Charts in Excel are a powerful function, and many people do not utilize their capabilities to the fullest. Visuals are meant to help you see trends, and help you analyze. Whether it is related to general business, or other industries, you may be asked to create charts.
Stacked bar charts are useful, however, the ability to see trends starts to decrease when you start looking at too many different series. Throughout this article, I’ll also be showing you how to create live chart textboxes within.
The company that I’ll be using as an example is Union Pacific (UP), the largest of the class 1 railroads in North America. Totals are helpful to analyze, but many times we need to dig deeper and understand every segment of a business. I’m speaking through a finance lens here, but should be applicable to your industry as well.
Here’s a stacked bar chart of UP’s freight revenues based on their filings:
As you can see, it is a pretty chart, but you can’t really tell what’s going on with the business…