Open Access   Article Go Back

Advanced Charting Techniques of Microsoft Excel 2016 Aiming Visualization

Kirti Nilesh Mahajan1 , Leena Ajay Gokhale2

Section:Research Paper, Product Type: Journal Paper
Volume-7 , Issue-1 , Page no. 198-207, Jan-2019

CrossRef-DOI:   https://doi.org/10.26438/ijcse/v7i1.198207

Online published on Jan 31, 2019

Copyright © Kirti Nilesh Mahajan, Leena Ajay Gokhale . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

XML View
PDF Download

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: Kirti Nilesh Mahajan, Leena Ajay Gokhale, “Advanced Charting Techniques of Microsoft Excel 2016 Aiming Visualization,” International Journal of Computer Sciences and Engineering, Vol.7, Issue.1, pp.198-207, 2019.

MLA Style Citation: Kirti Nilesh Mahajan, Leena Ajay Gokhale "Advanced Charting Techniques of Microsoft Excel 2016 Aiming Visualization." International Journal of Computer Sciences and Engineering 7.1 (2019): 198-207.

APA Style Citation: Kirti Nilesh Mahajan, Leena Ajay Gokhale, (2019). Advanced Charting Techniques of Microsoft Excel 2016 Aiming Visualization. International Journal of Computer Sciences and Engineering, 7(1), 198-207.

BibTex Style Citation:
@article{Mahajan_2019,
author = {Kirti Nilesh Mahajan, Leena Ajay Gokhale},
title = {Advanced Charting Techniques of Microsoft Excel 2016 Aiming Visualization},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {1 2019},
volume = {7},
Issue = {1},
month = {1},
year = {2019},
issn = {2347-2693},
pages = {198-207},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=3485},
doi = {https://doi.org/10.26438/ijcse/v7i1.198207}
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
DO = {https://doi.org/10.26438/ijcse/v7i1.198207}
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=3485
TI - Advanced Charting Techniques of Microsoft Excel 2016 Aiming Visualization
T2 - International Journal of Computer Sciences and Engineering
AU - Kirti Nilesh Mahajan, Leena Ajay Gokhale
PY - 2019
DA - 2019/01/31
PB - IJCSE, Indore, INDIA
SP - 198-207
IS - 1
VL - 7
SN - 2347-2693
ER -

VIEWS PDF XML
753 390 downloads 236 downloads
  
  
           

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.

Key-Words / Index Term

Microsoft Excel 2016, Visualization, Charting Techniques, Structured Data

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.