Visualization D, Data Bars, Pie Chart, Shape Fill, II
An Excel tutorial by Peter Kalmstrom
In earlier demos you have learnt about the data bars, format
a range of cells as a table and pie chart. In this demo
in the Excel 2016 from Scratch series, Peter Kalmstrom shows
how to make data more visible by using the same Excel tools.
How to format cells and change the text alignment.
How to add thousand separators to numbers in the
selected cells.
How to add data bars in different colors by using
the Conditional Formatting tool.
How to add different Icon Sets by using the Conditional
Formatting tool.
How to format a range of cells as a table by using
the Format as Table tool. Note that this is possible
only if the range has no blank rows or columns!
How to change the column name.
How to Insert a slicer.
How to insert a pie chart.
How to fill a part of the pie chart with color using
the Shape Fill tool.
How to add Data Labels by using the Add Chart Element
tool.
Peter uses Excel 2016 for his demo, but the Excel visualization
tools are the same for later versions of Excel.
In earlier demos you have learnt about the data bars, format
a range of cells as a table and pie chart. In this demo
in the Excel 2016 from Scratch series, Peter Kalmstrom shows
how to make data more visible by using the same Excel tools.
