Home
>
Tips
>
Excel 2016 from Scratch
>
Visualization G, charts and sparklines
Site map
Excel 2016 from Scratch Exercise
Visualization G, Charts and Sparklines
An Excel tutorial by Peter Kalmstrom
In this exercise in the Excel 2016 from Scratch series, Peter Kalmstrom shows how to use charts and spark lines to visualize information.
As an example Peter uses data for efficiency improvements in different departments of a company over three years.
Exercise
If you want to try the exercise yourself, please
download the Excel file Peter uses in the demo
!
Content
This is what Peter shows in the demo below:
How to add percentage to numbers in a selected range.
How to
select the range for a chart
, also when the parts are
separated
.
How to
change the name of a chart
.
How to
select several charts
.
How to
top align charts
.
How to
make charts horizontally distributed
.
How to
add sparklines
in a column to the right of the data.
Peter uses Excel 2016 for his demo, but the Excel visualization tools are the same for later versions of Excel.
Products
Buy
FAQ
Services
Tips
Books
Contact
About Us
Tools
Security and integrity
Copyright Kalmstrom Enterprises AB All rights reserved
In
this exercise in the Excel 2016 from Scratch series, Peter
Kalmstrom shows how to use charts and spark lines to visualize
information. 
