Troubleshooting Problems in Excel Charts: Missing Data Creates an Ugly Chart

Charts

There’s another tip in this blog, “When data points are bad or missing, how do you create a usable and decent looking Excel Chart?”, that describes how to use the NA() function to fix data series where some data are missing or there is a zero data that causes an “ugly” or invalid chart. This tip will show you three different ways to resolve the issue.

Look for the article, “When data points are bad or missing, how do you create a usable and decent looking Excel Chart?”

 

Share the power...