Entries that contain only numbers, dates, or times are not automatically completed.
After Excel completes what you started typing, do one of the following: To quickly fill in several types of data series, you can select cells and drag the fill handle .
My experience with pasting Excel 95 was that instead of continuing a row across it also frequently jumped down a row besides for what should have been on the same row.
The following macro attempts to fix that and is dependent on there being a value in Column A for every row in the original. Calculation = xl Automatic '--Excel 95 Application.
Location: these additional related macros) Home Page: refer to Getting Started with Macros.
For information about how to manually enter data, see the article Enter data manually in worksheet cells.
You need a chart, a set of values for the scaling parameters, and some VBA code to change the axis scales.
The code can be either linked to a button, or run from a event procedure.
To use the fill handle, you select the cells that you want to use as a basis for filling additional cells, and then drag the fill handle across or down the cells that you want to fill.
By default, the fill handle is displayed, but you can hide it, or show it if it's hidden.
You can let Excel scale the axes automatically; when the charted values change, Excel updates the scales the way it thinks they fit best. Or you could assign the code to a button in the worksheet. A more elegant approach is to change the relevant axis when one of the cells within B14: C16 changes.