Results 1 to 3 of 3

Screwed up Trendline

Threaded View

  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

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