Adding a pie chart footer and insert value based on field? Not sure if its do-able.

Jeff S
Jeff S used Ask the Experts™
on
Is it possible to add a footer to the bottom of a Pie Chart and have it pull the name based off a report parameter?

In my report, I have two pie charts displaying the top ten payers for the Month to Date and Year To Date. When the {Data.Indicator} = "M", I would like to have the footer equal "Top Ten Payors - Current Month" and when {Data.Indicator} = "Y" I would like the footer print out "Top Ten Payors - YTD".

Is this do-able??
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
As far as I know you can't do that.

This article indicates a similar change requires using a formula in the Group header or footer not in the chart

mlmcc
mlmcc,

 I don't see any article link.


 Jeff,

 Off the top of my head, one brute force solution might be to have two copies of the chart with different footers, in different sections, and suppress one section or the other based on that field.

 James

Author

Commented:
Thank you kindly.
You're welcome.  Glad I could help.

 FWIW, there may be a better way to handle that.  I don't really use charts.  That was just one obvious approach.

 James

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial