adding data to an exisitng series

[greco]

I have upgraded from 2003 to 2007 and find I can't add additional values to
an exisitng series. When I click on the series chart I get the function
showing at the top. Before, I could go and add the formula pertaining to the
new fields I wanted to add - now, once I have done that it will not allow me
to click on the tick and therefore add it in.
Please help - I have tried everything I can think of and can't get it to work.

 

[ShaneDevenshire]

Hi,

I'm not sure what you mean by click the tick. However, you can modify the
SERIES formula in 2007 just like you could in 2003. However, it might be
easier to just select the series on the chart and then drag the range sizing
handles down or to the right in the spreadsheet. The sizing handle appear at
the bottom right corner of the series' range. You size by placing the mouse
over the blue (or whatever color) square and dragging.