Table chart with titles and sub titles

[#1]

there is any way to create chart with titles and sub titles?

like that

QTY		AVG
actual	Last year	actual	Last year

[rbecher]

Hi,

just use a pivot table with two dimensions and drag first dimension (a synthetic dimension made of valuelist('Qty', 'Avg')) to upper right.

- Ralf

[#3]

The problem is that not all the columns are the same

see a better example

https://docs.google.com/spreadsheet/pub?key=0AtNOGiRvmUIWdFNXYmZFWkRjeThjU3hHd1JmQ0dvanc&output=html

[rbecher]

This is no problem. Dimension values (columns) only appear if values exists..

[#5]

Thank you

I do not really understand, how I define three specific columns will be assigned to QTY and other columns are assigned to AVG, and more and more

This realistic example

https://docs.google.com/spreadsheet/pub?key=0AtNOGiRvmUIWdFNXYmZFWkRjeThjU3hHd1JmQ0dvanc&output=html