Visualization Process involves seven steps, Acquire, Parse, Filter, Mine, Represent, Refine and Interact. However, the outcome of data analysis may not be adequate to provide the knowledge. During this entire journey, the data has to travel through various phases including Data Analysis and Data Visualization. The complexity of the data increases with the increased number of dimensions of data. This original data has various dimensions, several logical formats like text, numbers and also physical structures such as structured, semi-structured and unstructured. Thus, this journey originates from Data, reaching to Knowledge. The voyage of data begins with collection of data, followed by storing this data in precise format, further traveling through the process of Data Analysis and Data Visualization, ultimately concluding the journey by reaching to valuable knowledge. The purpose of this research paper is to present how advanced charting techniques can be used for visualizing varied data types in the engineering manufacturing industries. This paper describes illustrations of new chart types of Microsoft Excel 2016 along with their elements and respective attributes. In addition to these conventional charts, Microsoft Excel 2016 presents six advanced chart types named, Box and Whisker chart, Funnel chart, Histogram chart, Sunburst chart, Treemap chart and Waterfall chart to present the data differently. Various charting techniques such as Column Chart, Pie Chart, Line Chart and Bar Chart are existing in Microsoft Excel application. However, the most extensively used technique is to present the data in a chart format.

There are numerous techniques of visualization.

Visualization plays a vital role in decision making at various levels in the organization. Visualization supports extracting and understanding the information as it is represented in a graphical format. After the data is stored in a precise structured format, further analysis and visualization of data is essential to discover the hidden valuable insight from the large dataset. Environment of Microsoft Excel integrates storage, analysis and visualization of data.

How do i make a pie chart in excel 2016