What is a bar graph

Explanation of diagram types

You can use charts to graphically compare data. For example, bar charts give a good overall picture of your data set, but they are not easy to read when there are many bars. Bar charts also give the impression that data values ​​are frozen. If your data changes continuously over time, a line chart may be more appropriate. The best way to compare the proportion of a data series (individual bar) to the sum of all data series (all bars) is in a pie chart.

Use:

For

Column chart or bar chart

Compare two or more numeric values ​​recorded at different times or under different conditions. Good for comparing increases and decreases, highest with lowest value, numbers or frequencies.

A column or bar chart based on a data series is suitable for comparing values ​​within a data category, e.g. B. the monthly sales of a single product. A column or bar chart based on several data series is suitable for comparing data categories, e.g. B. the monthly sales for several products.

Use a line chart to compare more than 15 data points.

Stacked column or bar chart

Compare a part with the whole. Each column or bar in the chart compares multiple data points within a category. Use a stacked bar chart to compare annual sales figures for products over multiple years. Each segment of a bar chart compares specific product sales, each bar shows total product sales per year, and the full chart compares total sales for all years.

To display only a single series of data in the chart, use a pie chart.

Positive / negative bar chart

Comparison of positive and negative values. Positive values ​​appear above and negative values ​​below the midpoint (zero by default). You can define your own center point. Use a positive / negative graph to compare income versus loss or to track productivity over time.

Pie chart

Show the relationship of each data series value to the total of all data in the series shown. Ideal for showing proportions within a single data series. You can display percentage values ​​for each data point (segment in a circle).

Pie charts are most effective when at least one of the segments is 25% to 50% of the whole. Because it is difficult to compare sections of a pie chart or to compare the data between multiple pie charts, pie charts are often used when just a general comparison is required.

Line diagram

Display data that changes continuously over time (trends), such as historical financial data. Line charts connect adjacent series of data points with a line. Each data point represents an individual measurement. Line charts are a good way to show the rise or fall of values ​​over time.

Use a line chart to compare the total monthly sales of four regions over the span of a year. By displaying the same series of data as a bar graph, you can easily compare totals by region. Use a line chart to show upward or downward trends or cycles across all regions.

Area chart

Show data trends over time with an emphasis on highs and lows and the movement between data points. In charts that contain multiple data series, the quantitative difference between the data series is emphasized by the different colors in the chart.

Scatter plot

Draws X and Y coordinates as individual values ​​to reveal correlation patterns. If the trend of data values ​​increases from left to right, then the trend is considered positive. If the trend is falling from left to right, then the trend is considered negative. If the data points do not show a clear slope, the data is considered disjointed. A scatter chart can compare large amounts of data points without reference to time. Use a scatter chart to compare the number of beverages sold in a pub in terms of temperature changes throughout the day.

Bubble chart

Draw x and y coordinates as individual values ​​with a third data characteristic (the radius of each bubble). Bubble charts compare individual data points in terms of their size. Use a bubble chart to show market share by comparing the number of products sold, sales figures per product, and the percentage of total sales for each data point.

Further topics

Create quick charts

Create and edit diagrams in layout mode