Updating active cells into vba proofstate not updating
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. For this I used the code for testing, Msg Box IIf(Active Cell. Color Index = 3, "Yes", "No") But this does not work.
You should turn on the macro recorder and format an axis manually to make sure you use correct syntax in your procedure. 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. The title may be typically simple but I did not get a solution yet even after researching over several forums on the net. I have an excel workbook where few columns uses if conditions that refers other cells.