Help removing the grand totals on cluster column layout 5 - graph only not table

[rosscortb]

Hello

I created the joint graph/ table chart and is there a way to remove the grand total on the chart so the bar doesn't appear but still show the grand totals in the table? see screen shotCapture.PNG

Thanks

Ross

[Roel Jongman]

set the color for that bar to no fill and no border, than it won't show but stll be in your table

[rosscortb]

That doesn't really work as you are left with grand totals at the end of the graph above the column grand total
Capture.PNG

[Roel Jongman]

well the table you are using is based on the columns included. So if you remove grandtotals from the graph entirely then it also will be removed from the table.. the table is not a mini spreadsheet where you can do calculations. it just repeats the values of the data included in the graph.