Cyberdude
05-12-2006, 02:07 PM
I can (and do) create titles for charts that contain variable information. When I create the title box, I simply give the address of where the information is on the active worksheet. When that information changes, the info in the chart title changes correspondingly.
I am now trying to do the same thing with a point label on the chart. I wrote a macro that creates a Series consisting of a single point, then it creates a label for that point, then it provides the address of the info I want to be in the label. It works just fine.
My problem is that the info I want to be in the label is variable. When certain values on the chart change, I want the value in the label to change. I try to accomplish this magic by having a formula in the cell where the label gets its value. When I first create the label, it does display the information from the cell with the formula. However, when the formula produces a different value in the cell on the worksheet, the label on the chart does not change.
Is this the way it is supposed to work, i.e, once a chart label value is created, the label will retain that value forever and not respond to changes in the cell it is linked to?
I am now trying to do the same thing with a point label on the chart. I wrote a macro that creates a Series consisting of a single point, then it creates a label for that point, then it provides the address of the info I want to be in the label. It works just fine.
My problem is that the info I want to be in the label is variable. When certain values on the chart change, I want the value in the label to change. I try to accomplish this magic by having a formula in the cell where the label gets its value. When I first create the label, it does display the information from the cell with the formula. However, when the formula produces a different value in the cell on the worksheet, the label on the chart does not change.
Is this the way it is supposed to work, i.e, once a chart label value is created, the label will retain that value forever and not respond to changes in the cell it is linked to?