Including Totals in Chart's data table

C

Cat10

Is it possible to include totals within a chart's data table but not in the
chart itself? For example for you are charting 3 fields across 12 months and
want to show the total of the 3 fields for each month in the data table, is
there a way to do so which would allow the data to be "live" and updated as
the data source changes.
 
J

Jon Peltier

The data table only shows data in the chart. You can add the totals to
the chart, which puts them into the table, and then format the totals
series so it doesn't appear (no lines, markers, borders, fills).

- Jon
 

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

Similar Threads

List all tables, including document structure 0
Consolidation Table from Different Excel Tabs with Different Format 1
Create a chart from a table in word thats dynamic 0
Chart's DataTable 5
Creating a Chart on form from selected data in query. 0
Setting column width in a table with a macro is not working 0
Totals in the data table but not in the graph / chart 1
Data Table at Base of Chart 4

Top