Scribd
Upload
26 views33 pages

Excel Data Visualization Techniques

The document outlines various chart types in Excel, including column, stacked column, and line charts, emphasizing their utility in visualizing sales data across different stores. It also explains how to create pivot tables for data analysis and the steps to generate dynamic and interactive dashboards. Additionally, it highlights the process of adding charts to the dashboard for effective data presentation.

Uploaded by

sumrunkhan904
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
26 views33 pages

Excel Data Visualization Techniques

The document outlines various chart types in Excel, including column, stacked column, and line charts, emphasizing their utility in visualizing sales data across different stores. It also explains how to create pivot tables for data analysis and the steps to generate dynamic and interactive dashboards. Additionally, it highlights the process of adding charts to the dashboard for effective data presentation.

Uploaded by

sumrunkhan904
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Data Visualization

using Excel
Chart Types
Column Chart
• Column Chart
For example, television sales in Hammersmith are noticeably worse than the other two stores.
And sales of games and computers are consistent across all three stores.

• stacked column chart

The stacked column chart will enable us to compare the total sales of each department and the contribution of each
store to that total.

• 100% stacked column chart


The stacked column chart was great at comparing total sales. It also displayed the contribution to
those sales by each department, or store.
Column Chart
Bar Charts
Line Charts
Line Charts
Line Charts
Dynamic and Interactive Dashboard
in Excel
Data Set
Data Set

• Select all data ctrl+all


• Press ctrl+ t
• Select required col
• and remove extra columns (ctrl -)
For check error in data (error is exist
in last)
pivot table
• If create the chart then first create the pivot table
• that summarizes data from a larger table by grouping values into categories.
• Pivot tables can be used to analyze, explore, and present data.

How to create a pivot table in Excel


[Link] the cells that contain the data you want to analyze.
[Link] Insert > PivotTable.
[Link] where to place the pivot table.
[Link] OK.
pivot table
• Insert pivot table
pivot table
pivot table
Year wise check the YouTube channel
pivot table
Year wise check the YouTube channel
Distribution of channel by type
Distribution of channel by Country
(top 10)
(top 10) YouTube channel wise
subscribers
(top 10) YouTube channel wise
subscribers
Views wise channel
Top 5 categories wise earning
All pivot tables created
Pivot charts created
• Click on data
• Insert chart
• Select the chart
Table 2 chart • Add it in dashboard
Table 3 chart • Add it in dashboard
Table 4 chart • Add it in dashboard

You might also like