'Chart elements' category


You are here: Excel » Charts » Chart elements »

How to add a logarithmic trendline in a chart
Excel lets you easily add a best-fit curved logarithmic trendline calculated based on the method of least squares. How to […]
How to add chart gridlines
Chart gridlines are great for making the chart data more readable and detailed, Excel allows you to add major and […]
How to add Error Bars in a chart
Enable error bars when you want to show, for example, standard deviations in a chart, Excel lets you insert error […]
How to add a moving average to a chart
A moving average smooths out short-term variations to show a long-term trend or cycle. The chart above shows random values […]
How to add a linear trendline to a chart
Excel allows you to insert a linear chart trendline that displays a straight line calculated based on the method of […]
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 […]
Two y-axes in one chart
The image above demonstrates a line chart containing two data series and two y-axes, one for each data series. I […]
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 customize a chart data series
To change the looks of a data series simply double-press with left mouse button on with left mouse button on […]
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 customize chart axis
  Most Excel charts consist of an x-axis and a y-axis, Excel allows you to easily change the looks of […]
Excel chart components
  Charts in Microsoft Excel lets you visualize, analyze and explain data. Charting in Excel is very easy and you […]

Excel categories


Latest updated articles.
More than 300 Excel functions with detailed information including syntax, arguments, return values, and examples for most of the functions used in Excel formulas.
More than 1300 formulas organized in subcategories.
Excel Tables simplifies your work with data, adding or removing data, filtering, totals, sorting, enhance readability using cell formatting, cell references, formulas, and more.
Allows you to filter data based on selected value , a given text, or other criteria. It also lets you filter existing data or move filtered values to a new location.
Lets you control what a user can type into a cell. It allows you to specifiy conditions and show a custom message if entered data is not valid.
Lets the user work more efficiently by showing a list that the user can select a value from. This lets you control what is shown in the list and is faster than typing into a cell.
Lets you name one or more cells, this makes it easier to find cells using the Name box, read and understand formulas containing names instead of cell references.
The Excel Solver is a free add-in that uses objective cells, constraints based on formulas on a worksheet to perform what-if analysis and other decision problems like permutations and combinations.
An Excel feature that lets you visualize data in a graph.
Format cells or cell values based a condition or criteria, there a multiple built-in Conditional Formatting tools you can use or use a custom-made conditional formatting formula.
Lets you quickly summarize vast amounts of data in a very user-friendly way. This powerful Excel feature lets you then analyze, organize and categorize important data efficiently.
VBA stands for Visual Basic for Applications and is a computer programming language developed by Microsoft, it allows you to automate time-consuming tasks and create custom functions.
A program or subroutine built in VBA that anyone can create. Use the macro-recorder to quickly create your own VBA macros.
UDF stands for User Defined Functions and is custom built functions anyone can create.
A list of all published articles.