Visualizing Movements Along a Line in Excel

They say a picture is worth a thousand words… so how many does an animated graph get us? This morning I was working on a research proposal presentation. Essentially, the research aims to develop a way to measure, plot and visualize corporations’ strategic agility.  The conceptualization is influenced by the indifference curve in economics: An […]

Excel Tip: Freeze Chart Size from Cell Adjustments

As I mentioned in my MyExcelOnline podcast appearance, charting is one of the hardest Excel tools to master. My tip in the podcast showed how to add data with two keystrokes. Sizing your graph can also be challenging, especially when you add or delete cells. Snap! Stretch! Your graph changes size with cell adjustments. Follow […]

Pasting Data into an Excel Chart

One of the hardest Excel features to master is charts and graphs, which aren’t always so user-friendly. That “Select Data Source” dialogue box is so sensitive that it could drive you crazy! Select Data Source: a common source of frustration when working with Excel charts.   Turns out there is a way to add data […]

Excel Tip: Add Some Color to Your Chart!

One topic that I’m covering in my course on Excel for healthcare is data visualization and charts in Excel. I’m trying to cover just the basics, but finding it hard to do — there’s so much to learn about this topic.  But I’ll spare you the dissertation and show you this great trick I learned […]