Results 1 to 3 of 3

Thread: Getting Trendline in stacked column Excel Chart

  1. #1
    Join Date
    Feb 2012
    Posts
    10

    Getting Trendline in stacked column Excel Chart

    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.

  2. #2
    Join Date
    Nov 2010
    Posts
    422

    Re: Getting Trendline in stacked column Excel Chart

    "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 hat MS do not allow a trendline to be added to a Stacked Column Chart. Please hit Yes if my comments have helped.

  3. #3
    Join Date
    Nov 2010
    Posts
    503

    Re: Getting Trendline in stacked column Excel Chart

    If you add the total series to the chart, then convert it to a line chart type, you can right click on it and add a trendline. Maybe you know this, but unless the category axis is numerical (or at least evenly spaced, like Q1-Q2-Q3 etc), your trendline may be misleading or even meaningless.

Similar Threads

  1. How to disable excel for taking empty cell in Excel chart
    By Hache hi in forum MS Office Support
    Replies: 2
    Last Post: 25-02-2012, 12:30 PM
  2. Want help to display trendline in Legend in Excel
    By Henriksen in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 06:53 PM
  3. How to Extrapolating points on a trendline In Excel
    By CeLeStiA in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 01:16 PM
  4. Excel Function and Excel Chart Colors
    By Samarth in forum Windows Software
    Replies: 5
    Last Post: 13-01-2010, 08:16 PM
  5. Trendline formula is inaccurate in Excel
    By EDRIC in forum Software Development
    Replies: 1
    Last Post: 05-06-2009, 12:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,725,259.01828 seconds with 17 queries