merging a chart heading

[#1]

Hi,

i want to develop a chart as in attached excel. is it possible? pls help me on this

[#2]

hi, pls note that first and second colums are headings

[tresesco]

Have you tried pivot chart?

[#4]

!Yes You can try pivot chart. See the attached example for your data.

[#5]

hi,

how can remove the "+" mark in the pivot tables ?

[tresesco]

Right click on chart->Properties->Presentation tab-> check 'Always Fully Expanded'.

[sujeetsingh]

Tresco suggestion will work

[#8]

hi, the problem is I want to manual add the first row of headings with that grouping into a chart. is that possible to do?

[jagan]

Hi Dushan,

Select Always Fully Expanded option in Presentation tab.

Regards,

Jagan.