![]() The Hidden and Empty Cell Settings dialog appears. Click on Hidden and Empty Cells in the bottom left of the Select Data Source dialog that appears. ![]() Right click on the chart and choose Select Data, or choose Select Data from the ribbon. You can easily tell Excel how to plot empty cells in a chart. Excel’s Hidden and Empty Cell Settings Dialog ![]() ![]() tl drĪ new feature in Excel 2016, Show #N/A As An Empty Cell, solves the pain and frustration experienced by generations of Excel users trying to avoid plotting what look like apparently blank cells. I discuss the “plot blank cells” issue in several tutorials in this blog: Mind the Gap – Charting Empty Cells, Area Chart With Gap, Another approach to plotting gaps in Excel charts, and VBA Approaches to Plotting Gaps in Excel Charts, among others. There is a lot of confusion about plotting of hidden and empty cells, about what constitutes a blank cell, and about various workarounds that purport to produce blank cells that will or will not be displayed in a chart. A common problem around web forums and blogs is how to plot blank cells in Excel charts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |