Excel 2000 "Dead" Chart Links

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top