I changed a column from Manager ID to Manager Name. I set up a Prompt for Manager Name. I have a Grouping for Manager Name. On the Chart page, I selected Manager Name for my Y Axis. But when I run the report, the Y Axis shows "No Value" as the only option. What I was told is that Charts do not have the ability of registering text mode, and the workaround would be to use a custom field.
If I can create a field, I should be able to utilize it. So Charts need to be able to read what I've created on the report.