Excel users out there
Results 1 to 3 of 3
  1. #1
    Hall-Of-Famer
    Points: 64,618, Level: 78
    Level completed: 86%, Points required for next Level: 232
    Overall activity: 0%
    Achievements:
    SocialVeteran50000 Experience Points
    Cyclonesrule91's Avatar
    Join Date
    Apr 2006
    Location
    Waukee
    Posts
    4,961
    Points
    64,618
    Level
    78
    Thumbs Up
    Received: 22
    Given: 144

    Excel users out there

    I know there have got to be some Excel guru's out there that can help me with an issue I am having. If I am making a bar chart using information for the years 2000-2006 but have actual numbers for every other year, is there a way I can come up with a trend line on the graph without the trend taking into account every other year that is zero?

    I can pm back and forth with someone too so I don't take up valuable CF time when our first football game is so close and all. I will be in and out watching kids until I put them to bed so if someone answers I will be back.

    sorry in advance..



  2. #2
    Starter
    Points: 16,556, Level: 39
    Level completed: 14%, Points required for next Level: 694
    Overall activity: 2.0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Apr 2006
    Posts
    757
    Points
    16,556
    Level
    39
    Thumbs Up
    Received: 6
    Given: 0

    Re: Excel users out there

    Take out the zeors and leave the cells blank.



  3. #3
    Speechless
    Points: 343,854, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 21.0%
    Achievements:
    SocialVeteran50000 Experience Points
    ISUFan22's Avatar
    Join Date
    Apr 2006
    Location
    Grimes, IA
    Posts
    32,663
    Points
    343,854
    Level
    100
    Thumbs Up
    Received: 602
    Given: 369

    Re: Excel users out there

    Yeah, I think leaving the cells blank will work. If you can't get it, PM me and I'll have ya e-mail it to me - easier to fix and then instruct from there.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • TV: Cyclones.tv
  • HOOPS: Iowa State vs. Mississippi Valley State
  • December 31, 2014
  • 06:00 PM