Is it possible to link a chart and its data table so that a change in the
data is automatically reflected in the chart?

Hi,

Charts are automatically linked to their source range and by default if the
data changes the chart changes. So if you change a number in the data range
from 1 to 100 the chart will reflect that.

So if you are not seeing this behavior, what change are you making and
where? It suggests that the data changes are being made to data outside the
data range of the chart.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jeff Stanton" wrote:

Is it possible to link a chart and its data table so that a change in the
data is automatically reflected in the chart?

Shane,
I tried a change in the data, and it was reflected in the chart. What I
would like to do is ADD data points and see them reflected also. It doesn't
work, probably because the addition is outside the range of the chart. What
I am doing is charting monthly data, and I would like to avoid having to
generate an entirely new chart (actually a set of charts) each month.
Jeff

"ShaneDevenshire" wrote in
message ...
Hi,

Charts are automatically linked to their source range and by default if
the
data changes the chart changes. So if you change a number in the data
range
from 1 to 100 the chart will reflect that.

So if you are not seeing this behavior, what change are you making and
where? It suggests that the data changes are being made to data outside
the
data range of the chart.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jeff Stanton" wrote:

Is it possible to link a chart and its data table so that a change in the
data is automatically reflected in the chart?

Hi,

Ok, I see.

1. One way to do it is to click the chart and note that the data range has
blue and purple borders. At the corners of those borders are tiny squares,
these are sizing handles, you can simply drag them down or to the right.

2. If your new data goes on a new row, meaning that your data is laid out
vertically, and you are using 2003
- select the data and choose Data, List, Create List and click OK. If the
chart is created from this range and you type new data directly below, the
chart will automatically incorporate that data.
- in 2007 the command is Home, Format as Table.


There is a more complicated method for handling data which increases to the
right. Let us know if you need that.

If these help, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jeff Stanton" wrote:

Shane,
I tried a change in the data, and it was reflected in the chart. What I
would like to do is ADD data points and see them reflected also. It doesn't
work, probably because the addition is outside the range of the chart. What
I am doing is charting monthly data, and I would like to avoid having to
generate an entirely new chart (actually a set of charts) each month.
Jeff

"ShaneDevenshire" wrote in
message ...
Hi,

Charts are automatically linked to their source range and by default if
the
data changes the chart changes. So if you change a number in the data
range
from 1 to 100 the chart will reflect that.

So if you are not seeing this behavior, what change are you making and
where? It suggests that the data changes are being made to data outside
the
data range of the chart.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jeff Stanton" wrote:

Is it possible to link a chart and its data table so that a change in the
data is automatically reflected in the chart?

I'm using 2007, and the data increases to the right. I KNEW is probably
wouldn't be simple! :)

"ShaneDevenshire" wrote in
message ...
Hi,

Ok, I see.

1. One way to do it is to click the chart and note that the data range has
blue and purple borders. At the corners of those borders are tiny
squares,
these are sizing handles, you can simply drag them down or to the right.

2. If your new data goes on a new row, meaning that your data is laid out
vertically, and you are using 2003
- select the data and choose Data, List, Create List and click OK. If the
chart is created from this range and you type new data directly below, the
chart will automatically incorporate that data.
- in 2007 the command is Home, Format as Table.


There is a more complicated method for handling data which increases to
the
right. Let us know if you need that.

If these help, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jeff Stanton" wrote:

Shane,
I tried a change in the data, and it was reflected in the chart. What I
would like to do is ADD data points and see them reflected also. It
doesn't
work, probably because the addition is outside the range of the chart.
What
I am doing is charting monthly data, and I would like to avoid having to
generate an entirely new chart (actually a set of charts) each month.
Jeff

"ShaneDevenshire" wrote in
message ...
Hi,

Charts are automatically linked to their source range and by default if
the
data changes the chart changes. So if you change a number in the data
range
from 1 to 100 the chart will reflect that.

So if you are not seeing this behavior, what change are you making and
where? It suggests that the data changes are being made to data
outside
the
data range of the chart.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jeff Stanton" wrote:

Is it possible to link a chart and its data table so that a change in
the
data is automatically reflected in the chart?

Hi,

Well it's not that hard, it requires dynamic range names which are then used
in the range references.

Here are the steps in detail:

http://office.microsoft.com/en-us/ex...098011033.aspx

I will be writing up my own version in the near future, but right now this
site should do a satisfactory job.

If this information is helpful, please check the Yes button.
--
Thanks,
Shane Devenshire


"Jeff Stanton" wrote:

I'm using 2007, and the data increases to the right. I KNEW is probably
wouldn't be simple! :)

"ShaneDevenshire" wrote in
message ...
Hi,

Ok, I see.

1. One way to do it is to click the chart and note that the data range has
blue and purple borders. At the corners of those borders are tiny
squares,
these are sizing handles, you can simply drag them down or to the right.

2. If your new data goes on a new row, meaning that your data is laid out
vertically, and you are using 2003
- select the data and choose Data, List, Create List and click OK. If the
chart is created from this range and you type new data directly below, the
chart will automatically incorporate that data.
- in 2007 the command is Home, Format as Table.


There is a more complicated method for handling data which increases to
the
right. Let us know if you need that.

If these help, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jeff Stanton" wrote:

Shane,
I tried a change in the data, and it was reflected in the chart. What I
would like to do is ADD data points and see them reflected also. It
doesn't
work, probably because the addition is outside the range of the chart.
What
I am doing is charting monthly data, and I would like to avoid having to
generate an entirely new chart (actually a set of charts) each month.
Jeff

"ShaneDevenshire" wrote in
message ...
Hi,

Charts are automatically linked to their source range and by default if
the
data changes the chart changes. So if you change a number in the data
range
from 1 to 100 the chart will reflect that.

So if you are not seeing this behavior, what change are you making and
where? It suggests that the data changes are being made to data
outside
the
data range of the chart.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jeff Stanton" wrote:

Is it possible to link a chart and its data table so that a change in
the
data is automatically reflected in the chart?