Connect Line Data Points
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
Learn how to have gaps in a line chart when using the NA function in an Excel Formula
EXPLORE THE LIBRARY
admin
Chart
How-to Eliminate Statistical Outliers in an Excel Line Chart
Learn how to create a dynamic Excel chart where you can hide outliers in a Line chart or Line graph. Free Excel Template download file
Challenge
Friday Challenge – Eliminating outliers in and Excel Chart
how to make an excel chart that ignores outliers when plotted in a line chart. Do this without manually deleting the data points.
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.
Challenge
Friday Challenge – Create a Percentage (%) and Value Label within 100% Stacked Chart?
Friday Excel Challenge. Analyst question in Excel. Try and recreate it in an Excel Spreadsheet. Come back on Monday to see the solution.
Chart
Multi-Column Stacked Chart – How would you do it? – How I did it.
Step-by-Step Tutorial This is my solution to this week's Excel challenge. Learn how to put category names in a stacked column chart for your Excel Dashboard
Challenge
Stacked bar chart with data from multiple columns – How would you do it?
Quiz on making Excel stacked column chart with multiple columns that are grouped.
Guru
Excel Geek Out with MrExcel
Meetup and discuss excel
Excel Dashboard
How-to Create a Scroll Bar in Excel to Make Your Dashboard Dynamic
Learn how to use a scroll bar to dynamically change the data in the Excel dashboard chart.
Meetup
Excel Southern California Social – Meetup in Santa Monica Weds July 31 2013
come join us for an Excel social event.