Create a plugin with a backend report/charts generator. This will have a temp Admin menu and inside that menu will have a Charts menu and a Add new menu.
In the Charts menu, it will show a table with all the features as any WordPress table (Search, inline checkbox, Bulk Action, different Filters, etc). The table will show these columns:
• Chart Type
The Add new form will show the user with a two side/columns form. The left side will be for entering the report/chart data plus the SQL script for the data that the chart will use and the right side for a preview of the chart. The Charts will be using [login to view URL]
The different options for chart will be but not limited to:
• Verticar Bar
• Horizontal Bar
• Stacked Bar
Can give the ability to present the chart in 2D or 3D
Depending on the chart that is selected, the options for that kind of chart must be shown so the user can change it.
The table in the database that will hold the reports will have these columns
• id number
• name string
• slug string
• shortcode string
• script (for data) string
• chartOptions (array) string
In the frontend the chart that will be presented using the shortcode must cover the area where the shortcode is. If the shortcode is added to a 300px-by-300px div container, it must cover that area only or if the shortcode is added to the page itself it must cover the width of the page.