Hi,
The cause of the error message is :
If any grid is not bound to a Fetch based query then Charting engine detects it and throws the right error message as "The Chart could not be rendered for the selected filter criteria."
Please follow the below Workaround:
The idea is to put a subgrid on the account form that could display the opportunity chart.
1. Go to Settings – Customization – Customizations – Customize the System
2. In the left side Expand Entities and then expand Accounts
3. Select forms – open the main form (form type like main)
4. In the form body select Marketing Information section
5. On the Ribbon select Insert tab – then Subgrid
6. In this example please write like:
a. Name:
i. Name: chart
ii. Label: chart
b. Data source:
i. Records: all record types
ii. Entity: Opportunities
iii. Default View: My open opportunities
c. Additional Options:
i. View selector: show all views and specify a default chart
d. select the option “show chart only”
e. Go to Formatting tab – select two columns – number of rows put 10
7. Do OK
8. Save and close
9. Publish all customizations
10. Close the window when it publishes
11. Do F5 in your Internet Explorer
12. Go to accounts – marketing section
13. You’ll be able to see the chart, change the view and change the system charts too