Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi,
Replace the textbox comments with a comment in a Data Label. If you only want one comment, select the series, then single click the data point closest to where you want the comment. Choose Format, Data Point, and turn on Value on the Data Labels tab, click OK. Single click the data label, and then single click it again. Then type your comment and press Enter. Data Labels track the data points which means as you data changes the comment will travel up and down with the data point. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Marcin Peciak" wrote: Hi, I have a graph that is being updated weekly, so every time the X-axis extends. I add comment texts and / or pointers/lines to the graph from time to time. The problem I have is that each time I expand the graph (X range increases), I have to manually move the comments - because the graph is being rescaled. Is there any way to link the additional elements on the plot to be moved with the X-scale? Any suggestions? Many thanks, Marcin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding a line to my CF column graph - help! | Excel Discussion (Misc queries) | |||
Adding a slope line to a graph | Excel Discussion (Misc queries) | |||
Adding Horizontal line to a graph | Excel Discussion (Misc queries) | |||
Adding a line on graph | Excel Discussion (Misc queries) | |||
adding another axes with line graph | Charts and Charting in Excel |