Automatic trend analysis is provided on a dataset. Upon selection of a data cell or chart point within a data representation, a trend chart is automatically generated in order to demonstrate how the data within the selection trends over time. The system may automatically configure the trend chart based on the metadata of a data source associated with a selected data such that no input or configuration is needed by a user. The system may identify the time hierarchies and other data attributes included in the metadata of the data source associated with a selected data cell and may automatically configure the axis settings and the trend lines according to metadata of the data source. The trend chart may also be configured to display multiple trend lines for comparing multiple data set trends over a specified time period.