Notice: Undefined index: jqZoomEnabled in /home/mo/prod/old.dpk/cache/smarty/compile/43/5a/9e/435a9e65d628c4bc698502005ce09a0378998106.file.posts.tpl.php on line 72

Notice: Trying to get property of non-object in /home/mo/prod/old.dpk/cache/smarty/compile/43/5a/9e/435a9e65d628c4bc698502005ce09a0378998106.file.posts.tpl.php on line 72
href="/modules//smartblog/images/37.jpg" data-fancybox-group="other-views" class="fancybox shown" title="
Notice: Undefined index: imageTitle in /home/mo/prod/old.dpk/cache/smarty/compile/43/5a/9e/435a9e65d628c4bc698502005ce09a0378998106.file.posts.tpl.php on line 76

Notice: Trying to get property of non-object in /home/mo/prod/old.dpk/cache/smarty/compile/43/5a/9e/435a9e65d628c4bc698502005ce09a0378998106.file.posts.tpl.php on line 76
">

How to create a Sparkline graph on Excel 2016

  192315 Wednesday, August 16, 2017

1. Introduction
2. How to create a sparkline graph on Excel 2016?
3. Read more

The Microsoft Office 2016 suite includes new features and enhancements such as Excel 2016 graphic Sparkline feature. So How to create a Sparkline graph on Excel 2016?

What’s a Sparkline graph?

A Sparkline graph is a chart that is inside a cell or box in your chart that allows you to view the evolution and trend of the range of data you want to evaluate. A Sparkline graph is very useful if you have many columns or many lines and you want to get a glimpse of what is inside each one. so, how to create a graphic sparkline?

How to create a Sparkline graph on Excel 2016?

1- To insert a Sparkline chart select the box where you want to create your chart.

insert a graphic sparkline

2- Click on « Insert » tab and choose the « Graphic and Sparkline » option then pick the type of graphic you want to insert.

graphic sparkline types3- In the window that appears indicate the data that will be used to generate the graph and then specify the box where you want to insert your Sparkline then click on «ok».

graphic sparkline dara

4- To improve visibility you can increase the size of the line. You can extend the selection and drag it to the box beside it to have a Sparkline graphics based on the range of neighbouring cells.

data neighbouring range graphic sparkline

Buy excel 2016 >>

Click here for other Office articles.

Tags: excel 2016