Want to show legend just once for repeating charts

2019-09-03 13:37发布

I have 8 charts on a single page for 7 days of a week and one for combined. I want to show legend only once at the end of page.I have made visibility of legends for all 8 charts as Hidden. I have 3 rows and 3 columns of charts in which i have one space (i.e. 9th box in this 3X3 matrix of charts) free to display the legend. How could I do that? Thanks in advance.

1条回答
老娘就宠你
2楼-- · 2019-09-03 14:26

Take a look at last tip on this blog post: http://blog.hoegaerden.be/2009/10/25/pie-chart-techniques/

He overrides the colors from the palette using stored colors in the database.

In Series Properties you select Fill Page and click the Expression. Assuming you store the 6-digit hex value of the color, the expression will be:

="#" & Fields!YourColorCode.Value

This will ensure the colors will be the same across all charts. To create your "legend" just make a table that displays each field with it's color representation.

There is another question here: SSRS 2008 - Uniform Chart Legends for multi-chart report but the link in the answer no longer works.

查看更多
登录 后发表回答