Monthly Archives: July 1997

Custom exploded charts

Version 95 – In the last tip we showed you one way to produce an exploded Excel chart. There is another way, though; choose which slice to separate after you’ve already produced the chart. Let’s suppose you have a completed … Continue reading

Posted in Spreadsheets | Comments Off on Custom exploded charts

Exploding charts

Version 95 – If you want to place widely varying Excel data into a pie, doughnut, or three-dimensional pie chart, you’ll find that it can be hard to see the smallest segment. When you insert a chart in a worksheet, … Continue reading

Posted in Spreadsheets | Comments Off on Exploding charts

Autosave

Version 4.x – AutoSave is a handy Excel feature–one that saves many of us from disaster. Although Excel doesn’t use AutoSave by default, you can easily add it. Choose Tools|Add Ins. Some pamelaannschoolofdance.com generic levitra important guidelines to be followed: … Continue reading

Posted in Spreadsheets | Comments Off on Autosave

Rank and serial number

Versions 4.x, 95 – If you need to use the RANK function with data that’s presented horizontally, you need to enter each cell address. For example, Smoking cigarettes, obesity, poor control of blood glucose levels, and having diabetes mellitus for … Continue reading

Posted in Spreadsheets | Comments Off on Rank and serial number

Ranking

Versions 4.x, 95 – Do you ever need to rank your Excel data? Call on Excel’s RANK function. Let’s say you have a worksheet that contains sales data for your entire sales force, and you need to keep track of … Continue reading

Posted in Spreadsheets | Comments Off on Ranking

You gotta have art

Versions 4.x, 95 – Would you like to add a picture to the bars of an Excel chart to set them off? Try this, create a chart, then click away from the chart and choose Insert|Object|Microsoft ClipArt. The FDA said … Continue reading

Posted in Spreadsheets | Comments Off on You gotta have art

Grouping a chart and text box

Versions 4.x, 95 – When you add a label to an Excel chart using a text box, you’ll find that the text box doesn’t move along with the chart. To get around this, open the Drawing toolbar again. Now click … Continue reading

Posted in Spreadsheets | Comments Off on Grouping a chart and text box

Adding text to an existing chart

Versions 4.x, 95 – To add text to an existing chart, first choose View|Toolbars|Drawing to get the Drawing toolbar on the screen. Now choose the Text However, impotence cures in such a situation is rather disadvantageous for the normal menstrual … Continue reading

Posted in Spreadsheets | Comments Off on Adding text to an existing chart

Hidden cells

Versions 4.x, 95 – If you have a relatively small Excel worksheet that is determined to print several blank pages, make sure you didn’t place a formula in some obscure cell far removed from your work area. Some people will … Continue reading

Posted in Spreadsheets | Comments Off on Hidden cells