Tips and Tricks
My Excel Worksheet Only has 65000 Rows When Saving As Excel 2013 Workbook
When working between Excel 2003 and Excel 2007 or Excel 2013 formats you may run into errors. Here is an error that I recently received and how to fix it.
EXPLORE THE LIBRARY
/category/tips-and-tricks/page/5/
Chart
How-to Fake an Excel Chart Data Table
In this tutorial, you will see an extended technique on creating a more flexible Excel Chart Data Tables.
Chart
How-to Show Text in an Excel Chart Data Table (Part 1)
Learn 2 Excel Chart techniques on how you can create a more flexible Excel Chart Data Tables. One that shows how you can put in Text in the data table.
Challenge
How-to Close the Gaps Between Chart Series in an Excel Stacked Clustered Column Chart
Learn How-to Close the Gaps or shrink the white space Between Chart Series in an Excel Stacked Clustered Column Chart or Excel Stacked Clustered Bar Chart.
Chart
Stop Excel From Overlapping the Columns When Moving a Data Series to the Second Axis
Excel is not changing your chart to a Stacked Clustered Column Chart or Stacked Bar Chart when you move a data series to the secondary axis. How to fix it.
Challenge
Excel Clustered Column Chart Conundrum
how to move a data series to the secondary axis without overlapping the data series
Axis Formating
How-to Make a Pass Fail Chart in Excel
Step-by-Step Tutorial on making a visual representation of Pass / Fail data in an Excel Chart.
Concatenate
How-to Concatenate Excel Column or Row Data Using Google Docs
How to use Google Docs to Concatenate a range in Excel without the using a formula. Best for lots of data to concatenate or when you want to do it quickly.
100% Stacked Column Chart
Friday Challenge Answer – Create a Percentage (%) and Value Label within 100% Stacked Chart?
Friday Excel Challenge to Learn how to add percentages and value labels to the data series in an Excel 100% Stacked Column Chart or 100% Stacked Bar Chart.
Axis Labels
How-to Make Excel Put Years as the Chart Horizontal Axis Categories
Why won't Excel let me put years as my horizontal categories? Learn a quick and easy Excel trick on how to put Years in the horizontal axis category labels with this simple Excel Tip and Tri