Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text boxes and arrows on charts help
Hi,
I hope my description for what I'm trying to do is clear and easy to help with. I have a scatter plot and for some of the datapoints I would like to put text boxes on the chart to comment on important features of the data and arrows pointing from the text boxes to the relevant datapoints to which they are referring to. However, the chart will have additional data appended to it on many occasions in the future, which would grow the x and y axes. How can I make the text boxes and arrows move, for when the extra data is added, so that they always point/indicate the required datapoints? I don't want to have to keep moving text boxes and arrows manually each time. Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text boxes and arrows on charts help
Hi,
If possible use extra data series and data labels. Here is an example of the type of thing. http://www.andypope.info/ngs/ng47.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "stuart" wrote in message ... Hi, I hope my description for what I'm trying to do is clear and easy to help with. I have a scatter plot and for some of the datapoints I would like to put text boxes on the chart to comment on important features of the data and arrows pointing from the text boxes to the relevant datapoints to which they are referring to. However, the chart will have additional data appended to it on many occasions in the future, which would grow the x and y axes. How can I make the text boxes and arrows move, for when the extra data is added, so that they always point/indicate the required datapoints? I don't want to have to keep moving text boxes and arrows manually each time. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text boxes over charts | Charts and Charting in Excel | |||
Default font for text boxes and charts | Excel Discussion (Misc queries) | |||
Automatic updating for text boxes used on Charts | Excel Discussion (Misc queries) | |||
need a refresher: text boxes on charts that use relational formulas? | Charts and Charting in Excel | |||
Display Cell Data in titles/Text Boxes on Charts | Charts and Charting in Excel |