A chart data layout system and method of processing chart data in a report is provided. The chart data layout system comprises a query module for decomposing required data into required data queries, a chart layout module for rendering a chart based upon chart data received from the queries, a category module for displaying category aggregate information in a category location of a chart, and a series module for displaying series aggregate information in a series location of the chart. The method comprises the steps of decomposing required data into queries, retrieving queried data, rendering a chart based upon the queried data, rendering category information on a category label of the chart based upon queried data, and rendering series information on a series label of the chart based upon queried data.