|
|
 |
| Excel |
 |
-
Removing small value labels from Excel charts
Value labels on charts help in understanding the presented data.
However, if there are too many labels, the less important ones tend to clutter the image.
Removing them may help in making the results easier to analyze.
The Excel VBA macro presented here removes labels of values smaller than a given value.
-
Searching for Values in 2D Tables
A quick hint on how to search for data in Excel in two-dimensional tables (cross-tabulations).
-
Referencing Cells in Excel
Two exercises that should help Excel users (and users of other spreadsheets) refer to other cells in formulae.
Relative and absolute references are discussed using two examples:
calculating percents given counts, and calculating the multiplication table.
-
Open All and Merge
An Excel macro that shows how multiple sheets,
saved in different files, may be moved into a single common workbook.
Top
|
|
|
|
Texts
