Here's our Microsoft Office Tip for.. April 27, 2004
Click Here to see a complete list of all of our previously released Tips!
Hiding Charted Data
ypically, you want Excel to display data when you chart it, but not always. A good example of just such a situation is data that's charted by the month. You probably don't want to re-plot your chart as you add data for each month, so you probably plot the entire worksheet (from January to December) when you create the chart. However, doing so displays axis points for all the months, not just those for which you have data.
If you'd rather your chart not display points for months that have no data, you can hide the empty worksheet columns until you're ready to update that month. Excel won't chart the hidden columns. For example, if you have data only for the months of January through June, you can hide the worksheet columns from July through December. Then, when you run the chart, Excel will seem to plot only January through June. When you add July's data, you simply unhide the column, and Excel will add the new data to your chart--month by month.
To hide a column, simply select the column, right-click the selection, and then choose Hide from the context menu. Unhiding the column is just as simple--choose Unhide from the context menu.