Pie Chart Legend Problems

Pie Chart Legend Problems

Posted by: gphillips on 15 May 2025, 8:49 pm EST

• 

  gphillips

  • Post Options:
  • Link
    Copy

  Posted 15 May 2025, 8:49 pm EST

  I am trying to add a pie chart to a report as a sub report. The datasource generated from SQL Server and contains 2 columns: Initials and Hours. Sounds simple. I ran the wizard, set up the series with Initials as the X and Hours as the Y. It creates a pie chart, but the legend has the numeric values shown next to the color boxes instead of the Initials. The pie slices are correct based on the values, but I cannot figure out how to get it to show the Initials instead of the values. What am I missing?

  Any assistance would be greatly appreciated.

• 

  thomasfrank1803

  • Post Options:
  • Link
    Copy

  Posted 24 September 2025, 2:49 am EST

  You’re really closewhat’s happening is that the legend is defaulting to show the values instead of the label field. In the chart properties, check the Series → Legend Text (sometimes called “Label” or “Legend Expression” depending on your tool). Right now it’s probably set to =Fields!Hours.Value. Change that to =Fields!Initials.Value, and the legend should display the initials as you expect.
  
  If you also want the values visible, you can keep them as Data Labels on the slices, but let the legend only handle the initials.

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 24 September 2025, 4:41 am EST

  Hi Gary,

  We are not sure we fully understand your use case. To be able to comment upon the exact solution, could you please share a simple sample that demonstrates your scenario, so we can test the same on our end and further investigate the issue?

  Thanks,
  
  Anand