LL14
11-18-2014, 10:43 AM
Hello,
Background info:
I have a workbook in which I load in data. These data are then used to set up charts and pieces of texts after which Excel will open a specific word-file which will run a macro when opened. This will set up the text nicely and update linked charts with the new data.
The problem:
Some of the charts are colored conditional on the data. However, the change in color is not updated in Word. For example; the length of Bar1 in Chart1 in Word will adjust to the new data, but will not change from, say, red to green, even though the linked chart in Excel has changed.
So: Is there any way to make the (gradient) color in charts update in word automatically using VBA?
Thank you very much in advance!
Background info:
I have a workbook in which I load in data. These data are then used to set up charts and pieces of texts after which Excel will open a specific word-file which will run a macro when opened. This will set up the text nicely and update linked charts with the new data.
The problem:
Some of the charts are colored conditional on the data. However, the change in color is not updated in Word. For example; the length of Bar1 in Chart1 in Word will adjust to the new data, but will not change from, say, red to green, even though the linked chart in Excel has changed.
So: Is there any way to make the (gradient) color in charts update in word automatically using VBA?
Thank you very much in advance!