Creating Scrollable data ranges in Excel – Excel Form Controls: Scroll Bars
If Excel ever had a tongue it surely would have told us that eating thousands of rows is as delicious for it as dunking oreos in milk for humans!
But we humans have another issue and...
Highlight instances in Excel charts in different colors with shaded bars in background
Suppose you have a variance chart and want to highlight those that require inquiry. Further suppose that you have two levels of inquiry:
Variances that require moderate inquiry (highlighted by for example green color)
Variance...
Dynamically Highlight data points in Excel charts using Form Controls
Charts and graphs and other visual means make information easier to understand and analyze. Excel gives plenty of options in this department as different types of graphs are possible.
But in some cases wrong chart types in...