How to customize the chart legend
You can easily customize the font, font size, font color etc of the chart legend: Select legend. Go to tab […]
Latest blog articles
How to create a combined chart – Column and Line on secondary axis
The combination chart category lets you build a chart that has columns on the primary axis and the line on […]
How to create color scales [Conditional Formatting]
Color scales in conditional formatting applies a color to cells in a cell range based on their values, this lets you […]
How to use the F.DIST.RT function
The F.DIST.RT function calculates the right-tailed F probability for two tests. This function was introduced in Excel 2010 and has replaced […]
How to use the F.DIST function
The F.DIST function calculates the F probability for two tests. This function was introduced in Excel 2010 and has replaced […]
How to add Data Bars to your worksheet
Data bars allows you to insert a data bar into each cell in the selection, the size is based on […]
The FDIST function calculates the F probability of the right-tailed distribution for two tests. This function is outdated and is […]
The image above demonstrates a line chart containing two data series and two y-axes, one for each data series. I […]
The conditional formatting formula applied to cell range F3:F13 highlights all cells containing text. Here is how I did it: […]
How to use the EXPON.DIST function
The EXPON.DIST function calculates the exponential distribution representing an outcome in the form of probability. This function was introduced in Excel […]
How to use the EXPONDIST function
The EXPONDIST function calculates the exponential distribution representing an outcome in the form of probability. This function is in the compatibility […]
How to add and customize chart data labels
The image above demonstrates data labels in a line chart, each data point in the chart series has a visible […]
How to customize chart tick marks
The image above shows tick mars in a line chart, there are two types of tick marks, major and minor […]
How to use the BINOM.INV function
The BINOM.INV function calculates the minimum value for which the binomial distribution is equal to or greater than a given […]
How to use the CRITBINOM function
The CRITBINOM function calculates the minimum value for which the binomial distribution is equal to or greater than a given […]
How to customize a chart data series
To change the looks of a data series simply double-click with left mouse button on the data series. If you […]
How to use the CHISQ.TEST function
The CHISQ.TEST function calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees […]
How to use the CHITEST function
The CHITEST function calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees […]
The COVAR function calculates the covariance meaning the average of the products of deviations for each pair in two different […]
How to use the COVARIANCE.S function
The COVARIANCE.S function calculates the sample covariance meaning the average of the products of deviations for each pair in two […]
How to use the COVARIANCE.P function
The COVARIANCE.P function calculates the covariance meaning the average of the products of deviations for each pair in two different […]
How to create a sparkline – Win/Loss
A win/loss sparkline is a visual representation of a data series in only one cell, the image above shows a […]
The COTH function calculates the hyperbolic cotangent of a hyperbolic angle. The function has been available since Excel 2013. Formula […]
The XOR function was introduced in Excel 2013 and calculates the logical exclusive OR meaning if at least one of the […]
How to customize chart axis titles
The x-axis and y-axis titles are just as easy to format and customize as the other chart elements. How to […]
How to customize the plot area
The plot area refers to the location of the chart that displays the actual data represented by lines, bars, columns, […]
How to customize the chart title
I recommend that the chart title is short and easy to understand. How to add a chart title Follow these […]
How to customize the chart area
The chart area contains all components. If you choose to format the chart area you can change things like border, […]
How to use the CHISQ.INV.RT function
The CHISQ.INV.RT function was introduced in Excel 2010 and calculates the inverse of the right-tailed probability of the chi-squared distribution. […]
How to create a sparkline – Column
A sparkline is a visual representation of a data series in only one cell, the image above shows sparklines next […]
How to use the CHISQ.INV function
The CHISQ.INV function was introduced in Excel 2010 and calculates the inverse of the left-tailed probability of the chi-squared distribution. […]
How to create a sparkline – Line
A sparkline is a visual representation of a data series in only one cell, the image above shows sparklines next […]
How to use the CHIINV function
The CHIINV function calculates the inverse probability of the chi-squared distribution. The CHIINV function is outdated and you will find […]
How to use the CHISQ.DIST.RT function
The CHISQ.DIST.RT function was introduced in Excel 2010 and calculates the right-tailed probability of the chi-squared distribution. It has replaced the […]
How to create a candlestick chart
The candlestick chart allows you to plot price movements of stocks, derivates, bonds and currencies. A black candlestick in Excel […]
How to use the CHISQ.DIST function
The CHISQ.DIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. It […]
The surface chart allows you to graph multiple data series in a 3D chart, color-coded to make the chart easier […]
How to use the CHIDIST function
The CHIDIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. The […]
How to use the BINOM.DIST function
The BINOM.DIST function calculates the individual term binomial distribution probability, use this function when the success probability is constant through […]
A funnel chart is mostly used to display a series of steps within a process, each step shows a proportion […]
How to use the BINOMDIST function
The BINOMDIST function calculates the individual term binomial distribution probability, use this function when the success probability is constant through […]
How to use the BETA.INV function
The BETA.INV function calculates the inverse of the cumulative beta distribution. This function has replaced the BETA.INV function and was […]
How to create a Box and Whisker chart
The Box and Whisker chart allows you to plot distributions in statistics, it also displays local minimum, first quartile, median, […]
How to use the BETAINV function
The BETAINV function calculates the inverse of the beta distribution. This function is outdated and replaced by the BETA.INV function […]
How to use the BETA.DIST function
The BETA.DIST function calculates the beta distribution. It represents outcomes in the form of probabilities. This function was introduced in Excel […]
How to use the BETADIST function
The BETADIST function calculates the beta distribution representing an outcome in the form of probability. This function is in the compatibility […]
A Pareto chart is often used in statistics to demonstrate how sample values are distributed across given ranges, the values are […]
How to use the RANK.EQ function
The RANK.EQ function calculates the rank of a number in a list of numbers, based on its position if the […]
How to use the CONFIDENCE.T function
The CONFIDENCE.T function calculates the confidence range for a population mean using a Student's t distribution. Formula in cell C7: […]
How to create a histogram chart
The histogram chart lets you automatically group data values in intervals you specify, it is often used in statistics to show […]
Welcome! I am 