P
Phoenix
I've created a workbook which contains data on one sheet, and multiple charts
on one chart sheet that should be dynamically linked to the data sheet...but
aren't.
I placed multiple charts on one sheet by creating one "dummy" chart on the
sheet, then created embedded charts on the data sheet and moved them to the
chart sheet. After I'd done that (placing three embedded charts from the
data sheet on the chart sheet), I deleted the dummy chart and arranged the
other charts the way that I wanted them to display and print. I then used
this chart sheet as a template for other data sheets that would graph similar
results. I set the series ranges for each graph, and everything displayed
properly. But, if I change the data on the data sheet, the charts don't
automatically reflect the changes. The only way I can get them to display
properly is to re-select the data range for each series, but the chart still
will not dynamically change the data after that...I have to keep reselecting
the data range.
Have I accidentally done something to unlink the data? Help!
on one chart sheet that should be dynamically linked to the data sheet...but
aren't.
I placed multiple charts on one sheet by creating one "dummy" chart on the
sheet, then created embedded charts on the data sheet and moved them to the
chart sheet. After I'd done that (placing three embedded charts from the
data sheet on the chart sheet), I deleted the dummy chart and arranged the
other charts the way that I wanted them to display and print. I then used
this chart sheet as a template for other data sheets that would graph similar
results. I set the series ranges for each graph, and everything displayed
properly. But, if I change the data on the data sheet, the charts don't
automatically reflect the changes. The only way I can get them to display
properly is to re-select the data range for each series, but the chart still
will not dynamically change the data after that...I have to keep reselecting
the data range.
Have I accidentally done something to unlink the data? Help!