WAD Chart problem

Hello All,

I made a Bex query for a chart in WAD, it contains columns in 2 levels. For example, Company Code(5 company codes) and Month(3 months). When i see the out put of the chart, Company code text is being repeated for each month.

But if i see the same query in the Table object, company code is not repeated for all months, i.e for the 3 months, company code is appearing only once. But the same thing is not happening in Chart. If we have large numbr of Company codes, then Chart looks not very clear.

Could you please explain how can I do it in WAD Chart.

Regards,

Ravi