Bar Chart with trendline

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,
EricOne 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.
"EricJ" wrote:
> 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,
> Eric