Advanced Charting Techniques of Microsoft Excel 2016 Aiming Visualization

Authors

  • Mahajan KN Department of Information Technology, Institute of Management and Entrepreneurship Development (IMED), Bharati Vidyapeeth (Deemed To Be) University, Pune, India
  • Gokhale LA Department of Information Technology, Institute of Management and Entrepreneurship Development (IMED), Bharati Vidyapeeth (Deemed To Be) University, Pune, India

DOI:

https://doi.org/10.26438/ijcse/v7i1.198207

Keywords:

Microsoft Excel 2016, Visualization, Charting Techniques, Structured Data

Abstract

Environment of Microsoft Excel integrates storage, analysis and visualization of data. 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. Visualization supports extracting and understanding the information as it is represented in a graphical format. Visualization plays a vital role in decision making at various levels in the organization. There are numerous techniques of visualization. However, the most extensively used technique is to present the data in a chart format. Various charting techniques such as Column Chart, Pie Chart, Line Chart and Bar Chart are existing in Microsoft Excel application. 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. This paper describes illustrations of new chart types of Microsoft Excel 2016 along with their elements and respective attributes. 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.

References

[1] Kirti Nilesh Mahajan and Leena Ajay Gokhale, “Comparative Study of Static and Interactive Visualization Approaches”, International Journal on Computer Science and Engineering (IJCSE), e-ISSN: 0975-3397 p-ISSN: 2229-5631, Vol. 10 No.03, DOI: 10.21817/ijcse/2018/v10i3/181003016 Vol. 10 No.03 Mar 2018 85, pp.85-91, March 2018.

[2] Kirti Mahajan and Leena Ajay Gokhale, “Significance of Digital Data Visualization Tools in Big Data Analysis for Business Decisions”, International Journal of Computer Applications (IJCA), Volume 165 – No.5, pp.15-18, May 2017.

[3] Michael Alexander and Dick Kusleika, “Excel 2016 Formulas”, Wiley India Pvt. Ltd., India, pp. 425-467, 2016.

[4] Getting started with Excel 2016, Microsoft IT Showcase, January 2017.

[5] Greg Harvey "Excel® 2016 For Dummies®", John Wiley & Sons, Inc., pp. 295-329, ISBN 978‐1‐119‐07701‐5 (pbk), ISBN 978‐1‐119‐07702‐2 (ePub), 978‐1‐119‐07703‐9 (ePDF), 2016.

[6] Mantripatjit Kaur, Anjum Mohd Aslam, “Big Data Analytics on IOT: Challenges, Open Research Issues and Tools”, International Journal of Scientific Research in Computer Science and Engineering, Vol.6, Issue.3, pp.81-85, 2018.

[7] Rakesh. S.Shirsath, Vaibhav A.Desale, Amol. D.Potgantwar, “Big Data Analytical Architecture for Real-Time Applications”, International Journal of Scientific Research in Network Security and Communication, Volume-5, Issue-4, ISSN: 2321-3256, 2017.

Downloads

Published

2019-01-31
CITATION
DOI: 10.26438/ijcse/v7i1.198207
Published: 2019-01-31

How to Cite

[1]
K. N. Mahajan and L. A. Gokhale, “Advanced Charting Techniques of Microsoft Excel 2016 Aiming Visualization”, Int. J. Comp. Sci. Eng., vol. 7, no. 1, pp. 198–207, Jan. 2019.

Issue

Vol. 7 No. 1 (2019): IJCSE January Edition

Section

Research Article

License

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Authors contributing to this journal agree to publish their articles under the Creative Commons Attribution 4.0 International License, allowing third parties to share their work (copy, distribute, transmit) and to adapt it, under the condition that the authors are given credit and that in the event of reuse or distribution, the terms of this license are made clear.