![]() ![]() ![]() Gaps: this will leave gaps in your chart as shown above Then in the lower left-hand corner, click on "Hidden and Empty Cells": To access this dialog box, right-click on the chart and click on "Select Data…". The default for Excel in this instance is Gaps: But if I changed it to a line chart, here's what happens: ![]() ![]() If there were a couple years with no sales, and those cells were left blank, here is what the chart would look like: Using the keyboard shortcut Alt + F1, I can create a default column chart: If you get a preview, look for the download arrow in the upper right hand corner. You can download the file here to follow along. Here's how you can adjust your charts in Excel when they have hidden or empty cells: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |