You can build dynamic charts from non-cube data.
This can be any Excel range or directly from a SQL query or stored procedure. When inserting a small multiple chart from the Anaplan XL ribbon, you can specify the data source based on SQL or Excel ranges.