Charts Archives - TheSmartMethod.com

Publishers of the world’s most comprehensive and up-to-date Excel tutorials

Excel tutorials

The only Excel books you will ever need

The only constantly updated Excel 365 titles more…
Thoroughly covers Power Pivot and Power Query more…
Covers business intelligence and OLAP features more…
Simple, easy, understandable, 2-page lessons more…
Available as both printed books and e-Books more…
Used by schools, colleges and universities more…
Available for 365, 2021, 2019, 2016 and Mac versions more…

Category: Charts

Search again:

Standard deviation

Create a chart for the average and standard deviation in Excel

This article will show you how to create moving average and standard deviation charts in Excel and how to calculate this data using formulas.

Excel chart appears blank

Excel chart appears blank – not recognizing values?

This article shows you how to solve the problem if you find that values aren’t being recognized by Excel charts, including a sample workbook.

How to hide data in a chart that is zero

I do not want to show data in chart that is “0” (zero)

This article shows how to hide zeros from Excel charts. It also shows how to control how hidden and empty cells are dealt with by your charts.

removing gaps between bars in an Excel chart

Removing gaps between bars in an Excel chart

This article shows you how to change the width of the gaps between bars in Excel column charts, or remove the gaps entirely.

Categories

Recently added articles

Excel protected view warning

VLOOKUP inexact match illustration (chicken and egg).

VLOOKUP inexact match

VLOOKUP exact match

Microsoft Office update channels

Every lesson is presented on two facing pages

Excel linear and exponential series