Hi,

If your chart didn't include a title range then there is no purple border
available to expand. The blue border is stricly for the data, not the series
titltes.

1. Select the series on the chart and note the formula (on the Formula Bar),
something like this:
=SERIES(Sheet1!$E$1,,Sheet1!$E$2:$E$19,1)

See the ,, your series title range should be inbetween those. Click between
the commas on the formula bar and highlight the range where the series labels
are.
Press Enter.

--
Thanks,
Shane Devenshire


"veanmas" wrote:

When creating a chart in 2007, I select a range of data containing sales by
month. I forgot to select the column or cells cotaining the sales categories
so the chart shows series1, series 2, series 3 and so on. I expanded the
selected data by dragging out the colored box/border surrounding the selected
data, but the my chart did not updated. why? how can my chart update
automatically when modififying the selected area? Thought it was possible in
2007. Thansk