Line Chart, Area Chart, Stacked Area Chart, Line & Stacked Column Chart, Line & Clustered Column Chart, Ribbon Chart Visuals

Line Chart, Area Chart, Stacked Area Chart, Line & Stacked Column Chart, Line & Clustered Column Chart, Ribbon Chart Visuals

  May 18, 2023    asghars

---

 The following dashboard uses the Sample - Superstore dataset to demonstrate the creation of:

• Line Chart
• Line chart depicts data which changes over the time e.g. showing the difference in profit over the time. 
• The horizontal axis shows the continuous values e.g. week, month or year etc. 
• The vertical axis shows the changes in data points we are interested in. This will be a statistical summary like a total or average.
• Area Chart
• Area chart chart combines line and bar chart to show changes in data over time. 
• The area chart uses transparent shading to show crossover.
• Area chart is used with multiple lines to show trend over the time or make a comparison between categories or groups e.g. comparing the profit and sales over the time.
• Stacked Area Chart
• Stacked area chart stacks multiple areas on top of each other. 
• The area chart uses solid colors to show crossover.
• The topmost line in stacked area chart will always represent the total when summing all the groups.
• Stacked area chart is used to track not only the total value, but also to understand the breakdown of that total by categories or groups.  e.g. analyzing the yearly sales.
• Line and Stacked Column Chart
• Line and stacked column chart combines the stacked column and line charts. 
• By combining stacked column and line visuals, we can make a quick comparison between two categories. E.g. comparing total sales and profits of different categories with line shows the trend of discount for each category. 
• Line and Clustered Column Chart
• Line and clustered column chart is the combination of line and clustered column chart.
• Just like clustered column chart it displays and compare multiple sets of data over the same categories along with line to shows the trend. E.g. total sales of different regions for all financial quarters with line showing trend of total profit over the quarters.
• Ribbon Chart
• Ribbon Chart is a stacked column chart combined with line chart but with one difference that is in stacked column chart categories are shown in the order it added to the axis; However, in Ribbon chart categories are ordered which has the highest value (rank).

Download PBIX file