Resolving Graphing Problems in Excel

摘要

With options from standard bar graphs to complex bubbles and multi-axes charts, data can be presented in various formats. However, many a times we need solutions to work around unique problems. We discuss some such work arounds for three graphing problems in this article. One of them is avoiding blank values from being plotted in line graphs. It may so happen that for a long time there are no data points available. Line graphs take these blank cells as 0 (zero) and, therefore, drop the line to intersect with the X-axis when a blank cell is encountered. Another problem is changing the format of Category Y-axis values depending upon the variable being plotted, ie, percentage or values. The third problem deals with avoiding showing the legend when all the data for a variable is deleted.