The actual mechanics of creating this chart are incidental to the discussion, but we’ll use the following simple data and chart (named “Chart 1”, the default name of the first chart created in a worksheet). In this example, the range B14: C16 is used to hold primary X and Y axis scale parameters for the embedded chart object named “Chart 1”.
This example can be expanded to include secondary axes, or to change other charts as well.
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. Or you can manually adjust the axis scales; when the charted values change, you must manually readjust the scales. We can use the has appeared automatically atop the module. Manual recalculation is useful when you have a large spreadsheet that takes several minutes to recalculate.Instead of waiting impatiently while it recalculates after every change you make, you can set the recalculation to manual, make all of your changes, and then recalculate at once.The cells B14: C16 can contain static values which the user can manually change, or they can contain formulas with your favorite axis scaling algorithms.
See how to set up axis-scaling formulas in Calculate Nice Axis Scales in Your Excel Worksheet. Value End With End Sub You can type all this into the code module, or you can copy it and paste it in. You can run the code by pressing Alt F8 to open the Macros dialog, selecting the procedure in the list of macros, and clicking Run. Insert 3D models to see all the angles Use 3D to increase the visual and creative impact of your workbooks. Excel opens them faster, so you can crunch formulas with large ranges, filter lots of rows, or copy and paste quicker.You’ve created the reports for your management meeting, and, just before you print copies for the executives, you discover that the totals are all showing last month’s values. On the Formulas ribbon, look to the far right and click Calculation Options.On the dropdown list, verify that Automatic is selected.When this option is set to automatic, Excel recalculates the spreadsheet’s formulas whenever you change a cell value.