I can't work out how to make a 'total' line in data table...anyone have any idea?

MS-Off Ver: x is not valid
(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to "Post Quick Reply" button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

In order to appear in the data table of a chart it has to be a series in the chart.
As you are using a 3d stacked column the total series will also have to be part of the stack.

The data can be summed using a simple SUM formula

The total series can be formatted to have no fill.
You may also want to adjust the vertical axis Maximum to avoid too much space at the top of the chart.

FYI - example workbooks do not need to contain you actual data. They only need some data that demonstrates the problem.

For the total to be at the bottom of the stack it needs to be a negative value.
You can use a custom number format to remove the negative sign