Updating category axis excel utah gay dating

The code can be either linked to a button, or run from a event procedure.

4) do the same by highlighting each series and updating the categories. I had this same problem, thanks to this info i was able to fix it.

It is the first time it happens to me and I checked everywhere online and I don't see any reported issues that is similar to what I have or that provide a more satisfying solution than vba code. It is correctly linked to the source (no values hard coded).

The calculations are set on automatic for the workbook. I tried setting up an other chart in the same worksheet, linked to only one simple row and this new chart has the same refreshing issue so I suspect it has to do with settings or something like that but for the life of me I can't find which settings could do this.

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.

Wouldn’t it be great to be able to link the axis scale parameters to values or, even better, formulas in the worksheet? If you want a ready-to-use solution, try Tushar Mehta’s Auto Chart Manager add-in, available as a free download at You can write the entire procedure yourself, but it’s easier and more reliable to let the VB Editor start it for you.

Leave a Reply