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