Updating category axis excel
There are a few pieces you need to make this technique work. Click on the left hand dropdown at the top of this module, and select Private Sub Worksheet_Change(By Val Target As Range) With Active Sheet.
This example can be expanded to include secondary axes, or to change other charts as well.
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.
Here is the way I fixed this issue for my graphs without updating code.
My problem was that the y-axis categories weren't displaying the labels when I updated it each month with new data. 1) choose the "select data" option on the graphs 2) highlight the first series on the right, then click on the Category option and edit/reselect the categories.
See how to set up axis-scaling formulas in Calculate Nice Axis Scales in Your Excel Worksheet.
The parts of Excel’s charting object model needed here are the property could also be controlled, but I usually do not show minor tick marks).
A colleague and I have an issue with the refreshing of charts in excel.
The issue is the chart doesn't update when the source data is changed.
3) Then highlight the second series on the right, and then update the categories again. One of the answers above stated to select the label and hit the reset label text button in the label options for the chart you are working with.
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.
My chart now updates all the labels dynamically when they change on the data sheet.