Microsoft Excel provides the stock data type to display current stock prices and other information. However, the stock data type doesn't provide historical data. For historical data, you should use the STOCKHISTORY () function that provides all the same information about stocks for a specific date range.

There are countless reasons why you might need actual stock information, such as stock prices and changes, in your Excel spreadsheet. Previously, you had to copy and paste from Yahoo Finance or another financial service.

The most popular charts display data in one (as a pie chart, radar, or spider chart) or two dimensions (any type of line chart or scatter plot). If you need to display data in three dimensions, you can use 3D charts or bubble charts.

Combination charts are a great opportunity to create a really creative and memorable data presentation. Unfortunately, you can't choose the Bubble chart as an alternative chart type for line, area, etc. charts in the Change Chart Type dialog box (see Using two axes in the one chart). This tip shows how to combine two different chart types into one chart.

You may receive the “Excel found unreadable content in filename.xlsx” error when opening the Excel file. This error usually occurs if the Excel file is corrupted. However, there might be several other reasons that may cause this error. Let’s discuss the causes behind the error and the solutions to resolve it.

A speedometer, dial, or gauge chart displays a single value (usually displayed as an arrow) on a colored or sectored dial. The speedometer dial can be a half or a whole circle (the simplest option) or a sector located symmetrically vertically:

Scroll charts are often created to view detailed information for a small data range from a large dataset. For example, it is convenient to view weekly changes over a longer period of time, such as several months. Depending on the selected scroll step, you can view changes daily or weekly by moving the scroll bar.

The Scroll chart shows data for a long period in small scrollable time chunks. It makes easier to analyze data over a sufficiently long period in Microsoft Excel, Word or PowerPoint.
The Scroll chart displays some contiguous range of data from a large dataset. Using the provided Control tools, it is possible to add a scroll bar to the chart area and view the desired data range:

Sometimes you want to show a single chart with a series of different chart types. These charts containing data series with different chart types for each of them (lines, columns, areas, scatter, etc.) are called combo or combination charts:

If you want to combine more than two different data series with common horizontal and different vertical values, you could not just add another axis to the chart. You need to combine several charts into one chart.