Category Archives for "Business Analysis Charting with Excel"

Top 26 Best Excel Conditional Formatting Tips and Tutorial for Consulting Reports

Business Analysis Charting with Excel , Business Data Analysis with Excel

Top 26 Best Excel Conditional Formatting Tips and Tutorial for Consulting Reports After spending hours, days, or weeks in Excel searching through data, creating PivotTables and PowerPivots to find the answers you want those answers to POP OUT in your reports. Here are 26 great Excel formatting tips to help you create awesome reports for […]

Read More

Show or Hide Data and Charts with Dynamic Excel Reports

Business Analysis Charting with Excel

Show or Hide Data and Charts with Dynamic Excel ReportsWith a few simple lines of Excel VBA your static Excel reports can become dynamic. A single click shows or hides charts, objects, or rows and columns. Dynamic Excel reports give your users the ability to show or hide specific parts of reports, such as selected […]

Read More

Would You Like to Spy on Your Neighbor’s Dashboards? Here’s How.

Business Analysis Charting with Excel , Business Data Analysis with Excel

Have you ever wanted to see how others have designed a dashboard? Or what another organization’s Balanced Scorecard looks like? Come on. I know you have. Why learn things from scratch when you can stand on the shoulders of other good ideas. Seeing how others approach a problem can show you where you forgot something […]

Read More

Every Consultant Needs an Excel Pareto Chart to Improve Business Impact and Performance

Business Analysis Charting with Excel , Consulting Tools and Frameworks

Every Consultant Needs an Excel Pareto Chart to Improve Business Impact and Performance There are two or three charts that every consultant must know. One of those should be the Pareto Chart. You might know it as the “80/20 Rule.” This chart is the god of productivity improvement and impact. Pareto’s Rule, and its chart, […]

Read More

Microsoft Excel 2016 Charts and Analytics: Are You Ready? Can You Wait?

Business Analysis Charting with Excel , Business Data Analysis with Excel

Microsoft Excel 2016 was released September 22, 2015. Do you need its new charts and a few analytics gadgets it has added? I’m not so sure. However, if you work with teams there are some enterprise collaboration features that will make life less frustrating. (It works on Windows 7 SP 1 or later.) Overall, the […]

Read More

Vertically Scrolling Dynamic Sparklines Alongside a Database

Business Analysis Charting with Excel , Business Data Analysis with Excel

This Excel tutorial combines INDEX and Sparklines to create a window of vertically scrolling data and scrolling Sparklines. The “scrolling window” looks into a much larger database. The result is a very functional reporting technique that is cool and takes little space in Excel reports or dashboards. If you put the large database in a […]

Read More

How do Sparklines work with Non-Numeric or Hidden Data?

Business Analysis Charting with Excel , Business Data Analysis with Excel

Make sure you know how Sparklines work when their range includes non-numeric or hidden data. The data in the cell is the Sparkline Non-numeric ignores data and plots through non-numeric #NA ignores #NA and plots through #NA Blanks plots a blank Zero plots as zero Empty cells shows empty cells as you specify. See below. […]

Read More

Scrolling Dynamic Sparklines across a Horizontal Axis

Business Analysis Charting with Excel , Business Data Analysis with Excel

This tutorial combines dynamic range names with Sparklines so your dashboard users can scroll Sparklines through time. This gives your users the power to scan historical data trends across large amounts of data. (Sparklines are only available in Excel 2010 and newer.) Download the Sparkline Advanced file tutorial. Normally, Sparklines use a cell reference, such as […]

Read More

Top 7 Sparkline Tips for Consultants

Business Analysis Charting with Excel , Business Data Analysis with Excel

Here are some tips on working with Excel Sparklines. If you want to… then do this…    Change the size of Sparkline Change row height or column width Fill adjacent cells with Sparkline Drag handle in lower-right corner of Sparkline. The data of the additional cells must be in the correct orientation. Copy and paste […]

Read More

Creating Dynamic Charts in Excel that Resize Using the OFFSET Function and Named Ranges

Business Analysis Charting with Excel

Dynamic charts using Excel’s OFFSET and range names resize when data is added or deleted. Unlike using Tables for dynamic charts, this method is backwards compatible with early versions of Excel. Click to download the tutorial example file on dynamically resizing charts using OFFSET and range names. The example includes both horizontal and vertical data. The […]

Read More