Is there a way to have a column bar chart and have a moving average or
trendline inlcuded in the chart? Right now I have a simple column bar chart
which displays number of orders on the y axis and time of day on the x axis.
I have been requested to add a trendline for number of orders on the chart.
--
Thanks,

One solution is you could add the Trend or Average figures to your Bar Graph
and then change the style of this data series to be a line as follows:

1) Select properties on on the Chart.
2) Click on the Data tab.
3) Choose the Trend/Average data series under Values:
4) Click on Edit... button.
5) Click on the Appearance tab.
6) Click on 'Plot data as line' tick box.

Obviously you will need to calculate your trend/average as part of your data
retrieval. I normally write Table-value functions within the SQL
Server/Oracle database to return the data and allow me to perform these sort
of calculations.


[quoted text, click to view]