pivot chart legend shows "Sum of"

[matthijs]

Hello,

I have a query that I want to show in the pivot chart view. The legend shows
the field with "Sum of" in front. Even when I use an alias the "Sum of"
stays. Can I get this removed in some other way? I know the "Sum of" is
required to create a pivot, but is there a trick of not showing it in the
legend?

SELECT [overview test].date_date, [overview test].[skids company1],
[overview test].[skids company2], [overview test].[skids company4], [overview
test].[skids company4], [overview test].[skids company5], [overview
test].[skids company6]
FROM [overview test];

Regards,

Matthijs