J
Jeff Stanton
Is it possible to link a chart and its data table so that a change in the
data is automatically reflected in the chart?
data is automatically reflected in the chart?
S
ShaneDevenshire
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.
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.
J
Jeff Stanton
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
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
S
ShaneDevenshire
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.
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.
J
Jeff Stanton
I'm using 2007, and the data increases to the right. I KNEW is probably
wouldn't be simple!
wouldn't be simple!
S
ShaneDevenshire
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/excel/HA011098011033.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.
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/excel/HA011098011033.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.