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.
EXPLORE THE LIBRARY
Excel category
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.
Chart
How-To Copy an Excel Chart on Same Worksheet with a New Data Reference
This quick tutorial will show you how-to copy an Excel Chart on Same Worksheet such that it uses a new data reference instead of the original reference.
Averageif
How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs
A quick tutorial that teaches how to create an AverageIF Formula that will exclude Zero (0) and blank values when averaging across many Excel Worksheet Tabs
Challenge
How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)
Learn How you can Quickly and Easily Sum Across Excel Worksheets for the same Cells for every Excel Worksheets or Spreadsheet Tab
Chart
A Better Format For Excel Chart Secondary Axis Columns Overlap with 3 Series
Facebook Twitter Pinterest WhatsApp Linkedin Learn a better charting format when your Excel Chart Secondary Axis Columns Overlap with 3 data series. The Problem I didn’t love the last chart
Chart
Stop Excel Overlapping Columns on Second Axis for 3 Series
If you have 3 series in an Excel Column Chart and move one to the Secondary Axis, learn the trick on how to Stop Excel Overlapping Columns on Secondary Axis
Chart
Why is Excel Overlapping Columns When I Move them to the Secondary Axis?
Ever wondered why Excel Overlapping Columns occur when you move a chart series to the secondary axis? Read this article and see if you agree!