+ Reply to Thread
Results 1 to 2 of 2

Trendline Analysis

  1. #1
    Registered User
    Join Date
    07-22-2016
    Location
    Manchester, England
    MS-Off Ver
    Office 2010
    Posts
    7

    Trendline Analysis

    Hi

    I have created a custom chart in Excel which shows amount of profit per month in a bar format, with a secondary axis showing number of customers per month in a line format. I have added trend lines to both parts of the chart and both trend lines show a decline, however I would like to be able to see whether one of them has a steeper decline than the other. Is there a way I can do this?

    Hope that is clear, I'm not very technical!

    Thanks in advance!

  2. #2
    Registered User
    Join Date
    06-11-2015
    Location
    Stockholm, Sweden
    MS-Off Ver
    Professional Plus 2010
    Posts
    28

    Re: Trendline Analysis

    Hi,
    It would be easier if you would include an example file, but othervise I can think of two possible solutions.
    1. Would it help if you also showed the trendline in numbers to make even small differences more visible?
    2. Maybe if you change the axis values to a smaller range?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2010 Trendline With Data labels or number on forward forecast trendline
    By camelight in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-15-2015, 08:35 AM
  2. Replies: 1
    Last Post: 03-06-2014, 11:00 AM
  3. Replies: 2
    Last Post: 06-28-2013, 08:43 AM
  4. Data Analysis- advanced pivot functions for employee analysis
    By Dsankie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-10-2013, 12:30 AM
  5. Replies: 0
    Last Post: 10-11-2011, 03:22 PM
  6. Replies: 3
    Last Post: 03-06-2011, 01:38 PM
  7. [SOLVED] Analysis ToolPak installed but no Data Analysis option
    By Eric Stephens in forum Excel General
    Replies: 3
    Last Post: 02-02-2005, 06:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1