Trendline in Stacked Column Chart
EXCEL 2007
MS documentation states:-
"You can add a trendline or moving average to any data series in an
unstacked, 2-D, area, bar, column, stock, xy (scatter), or bubble chart".
Based on the above it seems that MS do not allow a trendline to be added to
a Stacked Column Chart.
Please hit Yes if my comments have helped.
Thanks.
"samcgui" wrote:
I have a stacked chart which shows data for 6 separate series identified by
month for 2010. What I am trying to do is include the data for each month
but only project a trendline using the data for months that have already
elapsed (for instance I would only want the trendline at the end of this
month to show the trend based on data for Jan, Feb, Mar and Apr).
I cant get a trendline on the graph at all let alone one that is constrained
to specific data.
I have tried including an additional data series which is the total of the
other 6 and then plot this on a secondary vertical axis in the hopes that I
could use this to create a trendline.
Can anyone help
|