software

I do a LOT of identically formatted graphs, and am trying to find a way to
speed up the process of changing the data label on a quot;Change Fromquot; column. I
have to keep this year's data, and indicate a change from last year. I used
text boxes, but I found that if I insert an additional series in the graph
and give it a value outside of the range of the X- axis, so the actual text
lines up on the outside end of the page it lines up perfectly with the bars
so I don't have to move them (with 100% overlap, and no formatting on the
actual bars themselves). However I then have to select each and every data
label and have it correspond to the cell with the real data in it (ie:
selected data label =$B$3) This can get very tedious when you have hundreds
of these graphs to do. Is there a better, faster, smarter way?????

Bar Value Change Value Value Outside Graph

A58510 615
B3787 615
C44235 615
D427(11)615
E4116 615
F39721 615
G39117 615
H38114 615Nevermind!!!

After looking through the posts for about 2 house I finally found what I
needed. thanks Andy Pope!!

quot;Riannequot; wrote:

gt; I do a LOT of identically formatted graphs, and am trying to find a way to
gt; speed up the process of changing the data label on a quot;Change Fromquot; column. I
gt; have to keep this year's data, and indicate a change from last year. I used
gt; text boxes, but I found that if I insert an additional series in the graph
gt; and give it a value outside of the range of the X- axis, so the actual text
gt; lines up on the outside end of the page it lines up perfectly with the bars
gt; so I don't have to move them (with 100% overlap, and no formatting on the
gt; actual bars themselves). However I then have to select each and every data
gt; label and have it correspond to the cell with the real data in it (ie:
gt; selected data label =$B$3) This can get very tedious when you have hundreds
gt; of these graphs to do. Is there a better, faster, smarter way?????
gt;
gt; Bar Value Change Value Value Outside Graph
gt;
gt; A58510 615
gt; B3787 615
gt; C44235 615
gt; D427(11)615
gt; E4116 615
gt; F39721 615
gt; G39117 615
gt; H38114 615
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;