Robjwalters
New Member
OK, so I have a scatterplot graph. Column A is a Risk number ( Risk 001), in column B is chance of Vulnerability ( 0-9 ) and Column C is the Likelihood (0-9).
When the plot is put on the chart, say at the intersection of 3-6, I also want it show the data label of the corresponding risk, say Risk 024.
I have everything working fine and the data labels work great ... until I close the workbook and reopen it. At this point everything will work except the data label. I have to reset the range and reset the label text.
How do I get it to update all the time? My calculations are set to auto...so not sure what I am missing.
I have attached the file, for your viewing pleasure lol
When the plot is put on the chart, say at the intersection of 3-6, I also want it show the data label of the corresponding risk, say Risk 024.
I have everything working fine and the data labels work great ... until I close the workbook and reopen it. At this point everything will work except the data label. I have to reset the range and reset the label text.
How do I get it to update all the time? My calculations are set to auto...so not sure what I am missing.
I have attached the file, for your viewing pleasure lol