If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
AppsPro XY Chart Labeler functionality
Hi
Does anyone know if the AppsPro XY Chart Labeler is able to dynamically update data point labels on a chart if the data in the 'label' cells changes? I would like to know before I install the .exe file. I have an XY chart with 256 data points derived from a 'master' formula with various inputs. If I change an input, the data point values will change and so will the associated labels. Many thanks |
#2
|
|||
|
|||
AppsPro XY Chart Labeler functionality
Hi,
The link to the cell will remain. So if you have a point linked to A1 and change the contents of A1 the data label will update. You can test this by doing it manually for a couple of data labels. Select the data labels, then select a specific data label. Now use the formula bar to enter an explicit cell reference, such as, =Sheet1!A1 Cheers Andy LFNFan wrote: Hi Does anyone know if the AppsPro XY Chart Labeler is able to dynamically update data point labels on a chart if the data in the 'label' cells changes? I would like to know before I install the .exe file. I have an XY chart with 256 data points derived from a 'master' formula with various inputs. If I change an input, the data point values will change and so will the associated labels. Many thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
AppsPro XY Chart Labeler functionality
Following your instructions for manually labeling a couple of data points, I
see that the link to the label cell remains, even though the XY values have changed and the contents of the label cell have changed. Groovy. So does the XY Chart Labeler automate the formula bar cell reference entry process...but the actual functionality of Excel remains unchanged? Many thanks Paul "Andy Pope" wrote: Hi, The link to the cell will remain. So if you have a point linked to A1 and change the contents of A1 the data label will update. You can test this by doing it manually for a couple of data labels. Select the data labels, then select a specific data label. Now use the formula bar to enter an explicit cell reference, such as, =Sheet1!A1 Cheers Andy LFNFan wrote: Hi Does anyone know if the AppsPro XY Chart Labeler is able to dynamically update data point labels on a chart if the data in the 'label' cells changes? I would like to know before I install the .exe file. I have an XY chart with 256 data points derived from a 'master' formula with various inputs. If I change an input, the data point values will change and so will the associated labels. Many thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
AppsPro XY Chart Labeler functionality
Yes, among other things the addin automates the linking of data labels
to cells. It's the addin I use most often. Cheers Andy LFNFan wrote: Following your instructions for manually labeling a couple of data points, I see that the link to the label cell remains, even though the XY values have changed and the contents of the label cell have changed. Groovy. So does the XY Chart Labeler automate the formula bar cell reference entry process...but the actual functionality of Excel remains unchanged? Many thanks Paul "Andy Pope" wrote: Hi, The link to the cell will remain. So if you have a point linked to A1 and change the contents of A1 the data label will update. You can test this by doing it manually for a couple of data labels. Select the data labels, then select a specific data label. Now use the formula bar to enter an explicit cell reference, such as, =Sheet1!A1 Cheers Andy LFNFan wrote: Hi Does anyone know if the AppsPro XY Chart Labeler is able to dynamically update data point labels on a chart if the data in the 'label' cells changes? I would like to know before I install the .exe file. I have an XY chart with 256 data points derived from a 'master' formula with various inputs. If I change an input, the data point values will change and so will the associated labels. Many thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
AppsPro XY Chart Labeler functionality
thanks for your help! "Andy Pope" wrote: Yes, among other things the addin automates the linking of data labels to cells. It's the addin I use most often. Cheers Andy LFNFan wrote: Following your instructions for manually labeling a couple of data points, I see that the link to the label cell remains, even though the XY values have changed and the contents of the label cell have changed. Groovy. So does the XY Chart Labeler automate the formula bar cell reference entry process...but the actual functionality of Excel remains unchanged? Many thanks Paul "Andy Pope" wrote: Hi, The link to the cell will remain. So if you have a point linked to A1 and change the contents of A1 the data label will update. You can test this by doing it manually for a couple of data labels. Select the data labels, then select a specific data label. Now use the formula bar to enter an explicit cell reference, such as, =Sheet1!A1 Cheers Andy LFNFan wrote: Hi Does anyone know if the AppsPro XY Chart Labeler is able to dynamically update data point labels on a chart if the data in the 'label' cells changes? I would like to know before I install the .exe file. I have an XY chart with 256 data points derived from a 'master' formula with various inputs. If I change an input, the data point values will change and so will the associated labels. Many thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
|
|||
|
|||
AppsPro XY Chart Labeler functionality
If you are using Excel 97 to 2003, the link will keep pointing to the
reference cell if you insert or delete rows or columns that change the link. However, if you are using Excel 2007, the link will not stay pointed to the reference cell. It appears to do so, until you change the value in the reference cell after inserting or deleting that should change the reference. A big bug in 2007...... Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "LFNFan" wrote in message ... Hi Does anyone know if the AppsPro XY Chart Labeler is able to dynamically update data point labels on a chart if the data in the 'label' cells changes? I would like to know before I install the .exe file. I have an XY chart with 256 data points derived from a 'master' formula with various inputs. If I change an input, the data point values will change and so will the associated labels. Many thanks |
Thread Tools | |
Display Modes | |
|
|