+ Reply to Thread
Results 1 to 3 of 3

Screwed up Trendline

  1. #1
    Registered User
    Join Date
    06-02-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    2

    Screwed up Trendline

    Hello - I have a chart with two vertical axis tracking sales of 3 people. v-axis 1 tracks a bar chart for products and services. v-axis 2 tracks a trendline for weighted pipeline sales. Everything is correct except for 1 of my four trendlines. By looking at my chart you can see the total weighted sales has a problem with the data/line, whereby between the 3rd and 4th data point the trendline nosedives down to zero. I cannot figure out how I fixed the problem for the 3 other lines. The data for the screwed up line is in column F. Thank you anyone for your help.
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Screwed up Trendline

    Select F17:F21 and press the Delete key.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-02-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Screwed up Trendline

    thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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