Excel 2016 2013 2010 2007 2003

Creating a Candlestick Stock chart

Candlestick chart is a style of bar-chart used primarily to describe price movements of a security, derivative, or currency over time. It is a combination of a line-chart and a bar-chart, in that each bar represents the range of price movement over a given time interval. It is most often used in technical analysis of equity and currency price patterns.

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 add labels to the Mosaic plot

This is the third and last part of the tip How to create a Mosaic plot in Excel (the second part is How to create a step Area chart for the Mosaic plot in Excel). The step area chart created in the previous part has invalid labels for both axes and no data labels:

How to create a step Area chart for the Mosaic plot in Excel

This is a second part of the tip How to create a Mosaic plot in Excel. The first part describes how to prepare the data for the step Area chart created in this part.

How to create a Mosaic plot in Excel

Pie and bar charts greatly simplify the understanding of percentages distribution for one categorical variable but fail to build a meaningful representation of two and more variables. A quite recent innovation in data visualization real is the Mosaic plot, which helps to grasp the correlations within marketing, sales, and other financial data. You will not find this chart among Excel standard charts, but you can build one.

How to add labels to the Marimekko chart

This is the third, last part of the tip How to create a Marimekko or Mekko chart in Excel (the second part is How to add separators to the Marimekko chart). The area chart created in the previous part needs data labels:

How to add separators to the Marimekko chart

This is the second part of the tip How to create a Marimekko or Mekko chart in Excel. In the first part of this tip, a step Area chart was created:

How to create a Marimekko chart or Mekko chart in Excel

The distribution of market shares or stocks of the investment portfolio often is illustrated by pie or doughnut charts. The illustration of multi-market shares and multiple investment portfolios calls for different approaches. The Marimekko chart (also known as Mekko chart, or mosaic plot) comes to the rescue.

Tally chart in Excel

A tally chart is a quick and easy way to record data by filling the chart with vertical bars each time a piece of information is observed. In addition, vertical bars (or tally marks) are immediately divided into groups of five (rarely groups of seven or ten).

Creating pictogram chart with colorful filling

A pictogram (also known as pictorgamme, pictograph, icon chart, pictorial unit chart, or picto) is a chart or graph which uses icons, symbols, illustrations, or pictures to represent data. Pictograms have become quite popular in modern infographics to present simple facts, but it is not obvious how to create this chart in Excel.