'Custom charts' category



How to build an arrow chart
This chart is an arrow chart that has horizontal and vertical lines, positive arrows are green and negative arrows are […]
How to graph a Normal Distribution
The chart above is built using the NORM.DIST function¬†and is called Normal Distribution¬†or Bell Curve chart. This curve is often […]
How to graph an equation
Why graph an equation? Graphs make it easier to analyze features of the equation like intercepts, increasing/decreasing, maxima/minima, concavity, etc. […]
Build a comparison table/chart
I found a chart that I wanted to show you how to build. It contains values both horizontally and vertically, […]
Heat map yearly calendar
The calendar shown in the image above highlights events based on frequency. It is made only with a few conditional […]
Advanced Gantt Chart Template
This Gantt chart uses a stacked bar chart to display the tasks and their corresponding date ranges. Completed days are […]

Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values

Excel categories