Excel 2016 2013 2010 2007 2003

Import a text file to an Excel spreadsheet

Often you need to import data to the Excel spreadsheet from a text file. Microsoft Excel offers a Text Import Wizard to import data from different text file formats:

Import a structured text file to an Excel spreadsheet

When you import data from a text file to the Excel spreadsheet, Microsoft Excel launches a Text Import Wizard to help you to import data correctly. Here you can import all or some data from text files of different formats:

How to remove the diamond with question mark symbol

When you paste or import data into the Excel spreadsheet, you might notice unusual symbols like a diamond with a question mark. The replacement character � (often a black diamond with a white question mark or an empty square box) represents an unknown, unrecognized or unrepresentable character:

Gantt chart with progress

Gantt chart is a horizontal bar chart that is often used in project management applications.

Creating a simple thermometer chart

A thermometer chart is a kind of progress chart that shows the current completed percentage of the task or the value of any metric relative to the predefined value. E.g., the thermometer scale can display the sales plan status or client satisfaction rate.

How to create a funny dog breeds lifespan chart in Excel

Span chart, also known as a range bar graph (range column graph), floating bar graph, difference graph, high-low graph, used to display the specific variable value range. Span charts are ideal for comparing ranges, and typically, each variable represents a particular category. All values for the selected category fall between minimal and maximal values that correspond to lower and upper bounds of the interval.

How to create a span chart in Excel

Span chart, also known as a range graph, floating graph, difference graph, high-low graph, shows dataset ranges between a minimum value and a maximum value:

How to create a box and whisker plot in Excel

When you work with some statistical data such as lifespan, weight, or height of the specific type of pets, you have different charts and diagrams to compare them. The box and whisker chart is one of the useful graphical representation of statistical data that that shows the median, quartiles, and extreme values at one plot.

How to create a break-even chart in Excel

A revenue the company generates from selling the products or providing the services should cover the fixed costs, variable costs, and leave a contribution margin. The point where the total operating margin (the difference between the price of the product or service and the variable costs per item or customer) covers the fixed costs is called a break-even point.

How to create a Heatmap chart in Excel

A Heatmap or Heat Map chart looks like a table, which cells colors depend on the cell value. These charts are popular in biology, web and other analytics, geography, etc. Tabular data transformation for time series data projects one-dimensional data into two-dimensional time matrices, which simplify frequent pattern analysis.