Wrapping up my series on dashboards, I want to address an issue I see in just about every spreadsheet I’ve seen in my career as a marketer: using Excel’s (hideous) default formatting for visualizations. You’ve seen them … the blue and red charts are particularly unforgivable. Worst of all, sticking with Excel’s default formatted table […]
I’ve been writing a series on how to create dashboards in Excel that started with this post on Search Engine Land and carried over to Marketing Land. Now, I’m going to show you a trick that will give you the ability to control an entire dashboard with one menu — in this example, a radio […]
Continuing with my dashboard series that began on Search Engine Land and continued over to Marketing Land when the entire analytics column migrated to Marketing Land, this post is going to talk interactive charts. When you’re creating a dashboard, real estate is minimal, so you find ways to consolidate your data and allow the dashboard […]
Last month, I promised a series on creating dashboards in Excel. To kick off the series, I started with a tutorial on how to create combination charts in Excel. Every marketer should have this critical skill mastered. You can expect this series to focus on cool visualizations in Excel. Next up, I’m going to show […]