Charts: Colour codes, fill/border, line formats and positioning should be dynamic
All colour codes, fill/border, line formats and positioning on charts should be able to be passed in from a range, named range or variable. This would essentially bring a basic "conditional" formatting to charts and cover the main things the users...
Actions: User icons should be variable in User confirmations
The icon displayed at the moment is 'hard coded'. The designer should be able to point to a svg/png file conditionally. For example, based on another condition in the spreadsheet could change the icon from one icon to another.
Ability to control/specify which symbol is used for data points ,e.g. for Actual, Prev. Year , Budget, Forecast different symbols needed as of those automatically assigned by engine #18238
Chart display units set automatically based on data
When using a chart to represent relatively large numbers, the K or M separator is used to better visualise the numbers. However, when users filter the data and smaller numbers are displayed the separator remains and then no number is shown. The re...
A clustered and stacked chart has clusters of columns or bars, with a stack in each column or bar. Similar to the example shown below: This type of chart can be used to compare actual vs. budget by category, for example.