Hiding A Specific Column

There may be times where you don't want Excel to chart columns of data where there is no data yet. For example, you have a budget running from January through December with a matching bar chart, but the months of November and December haven't arrived yet to include the data for June is incomplete. If you hide these noted columns, Excel will not attempt to plot them out and your chart will not only look better but show the accurate data. Follow these steps to hide and unhide columns:

In performing this tip, you will only chart data that is relevant.

Tip is extracted from Tipworld, visit their website for more tips by clicking on the globe globe
home button   Just click on the button for the Tiproom's Home Page.
Date of last revision: 29 August 2001.