Template

J

jlo

I'm creating a template in Word. It is possible to have a table linked to a
chart so the table updates the chart based on the data that is keyed in?
 
J

Jay Freedman

That's a built-in feature of Word. You don't use a regular table, though.

In Word 2003 or earlier, click Insert > Picture > Chart. After you choose a
chart type (bar, line, scatter, pie, etc.) it shows a data table that looks
like a section of an Excel worksheet. You enter your headings and initial
data to replace the sample. Save that in the template. When a new document
is based on the template, the initial data and chart will appear. The user
can double-click the chart to activate it, and the data table will appear
for editing. Changes are reflected immediately in the chart.

In Word 2007, click Insert > Chart. After you choose the chart type, it
opens an actual Excel worksheet with the sample data. Again, enter your
initial data and save the template. The user can select the chart, which
causes the Chart Tools tab to appear on the ribbon, and they can click the
Edit Data button there (or choose it on the right-click menu) to reopen the
Excel worksheet. The worksheet does not get saved separately; the data stays
in the Word document.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
J

jlo

Thanks Jay. The charts are set up that way already. However in the
template they also have a table with figures. They want the table to reflect
the chart. So I guess we could say they want to see the datasheet at all
times without it closing.
 

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