Chart
Create Dynamic Excel Chart Conditional Labels and Callouts
Learn this SIMPLE executive dashboard chart trick for conditional labels and callouts so you can QUICKLY identify individual data points.
EXPLORE THE LIBRARY
Excel
Ideas
Do you have an Idea to Make Excel Better? Excel’s Suggestion Box is Here!
Microsoft needs your help. Check out how you can influence Microsoft roadmap for the next release by submitting your votes on Excel’s Suggestion Box
How-To
Alternate Ways to Select Large and Non-Contiguous Ranges in Excel
Learn how to use alternate techniques to select very large ranges in Excel and also another way to select non-contiguous ranges.
Bar Chart
How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel Excel is awesome because, even when a certain chart type is not a standard option, there may be a way that you can create the type of chart that y
Challenge
Friday Challenge – My Answer – Chart This Data in Excel
Check out How I Used Different Graphing Techniquest to Chart This Data in Excel, including Pivot Tables, Slicers and Multi-Level Labels.
Chart
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months If you wanted to create a dynamic Excel chart of last 3 months of your data but didn’t know how to use or didn’t want to use the Excel Offset Function, then check out
Challenge
Friday Challenge – Chart This Data in Excel
Try your hand at this Friday Challenge to see how you would chart this data in Excel. What is the best ways to set up your chart data and format.
Chart
How-to Copy a Chart and Change the Data Series Range References
Learn several techniquest to Copy a Chart and modify the copy of the chart to change the data series range references to a new area in your worksheet.
Challenge
Friday Challenge Answer – Find Unique Values from CSV List
Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List Before we begin, I am going to show you how to do this with some standard Excel features
Challenge
Friday Challenge – Find Unique Values from CSV List
See if you can Find Unique Values from CSV List in Excel. This is a tough challenge, but will show you how you to work with CSV files and Pivot Tables.