Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,346
Default Adding a text/line from Drawbox onto graph

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a line to my CF column graph - help! Snow Excel Discussion (Misc queries) 3 May 27th 08 08:59 PM
Adding a slope line to a graph buddylee2506 Excel Discussion (Misc queries) 1 April 13th 07 07:24 PM
Adding Horizontal line to a graph WhytheQ Excel Discussion (Misc queries) 1 June 15th 06 02:42 AM
Adding a line on graph Dirk_Bob Excel Discussion (Misc queries) 0 December 14th 05 07:18 PM
adding another axes with line graph thongtran Charts and Charting in Excel 1 September 9th 05 09:21 PM


All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"