The DIS Discussion Forums - DISboards.com Excel experts - Help
 Find Hotel Specials & DIScounts Disney World Universal Orlando Disneyland Other
 User Name Remember Me? Password
 Register Chat FAQ Tickers Search Today's Posts Mark Forums Read

 Thread Tools Rate Thread Display Modes
 07-18-2013, 09:07 AM #1 jkjs Mouseketeer   Join Date: Apr 2008 Posts: 261 Excel experts - Help I am trying to plot some data and I am at a loss Here's the data ID: Student 1, Student 2, Student 3, ... Score: 65, 75, 80 .... I create a line plot of student vs score I want to add an average line to that plot. Is there a way in the Edit Data box to create a second data set where the x-values are the Student ID range (say A1:E1) and they all use the same Y value (say B2 which would be the average value). OR Do I need to change the data to be ID: Student 1, Student 2, Student 3, ... Score: 65, 75, 80 .... Average: 73, 73,73 ... and prepare the plot that way with one line being student vs score and the other student versus average. Last edited by jkjs; 07-18-2013 at 09:15 AM.
 07-18-2013, 09:22 AM #2 The Mystery Machine DIS Veteran   Join Date: Jan 2001 Location: Missouri Posts: 45,239 Go on You Tube, there are free tutorials.
|
The DIS
Register to remove

Join Date: 1997
Location: Orlando, FL
Posts: 1,000,000
 07-18-2013, 11:15 AM #3 Sadie22 DIS Veteran   Join Date: Feb 2010 Location: Maryland Posts: 2,178 Microsoft offers tutorials online for all of its software, not necessarily on YouTube.
07-18-2013, 11:18 AM   #4
sam_gordon
DIS Veteran

Join Date: Jun 2010
Posts: 9,980

Quote:
 Originally Posted by jkjs I am trying to plot some data and I am at a loss Here's the data ID: Student 1, Student 2, Student 3, ... Score: 65, 75, 80 .... I create a line plot of student vs score I want to add an average line to that plot. Is there a way in the Edit Data box to create a second data set where the x-values are the Student ID range (say A1:E1) and they all use the same Y value (say B2 which would be the average value). OR Do I need to change the data to be ID: Student 1, Student 2, Student 3, ... Score: 65, 75, 80 .... Average: 73, 73,73 ... and prepare the plot that way with one line being student vs score and the other student versus average.
I would do your second idea. There might be a more "elegant" way, but the ends justify the means in this case.

ETA: You could even "hide" the Average row so someone looking at the spreadsheet doesn't think it's that students average.
__________________
Freedom W. Caribbean June 15 - June 22, 2014 Video
Oasis W. Caribbean June 8 - June 15, 2014 Review
Barcelo Maya Palace June 29-July 6, 2012
Bay Lake Towers, WDW June 1 - June 6, 2011
Polynesian, WDW Dec. 29, 2008 - Jan. 3, 2009
Wilderness Lodge, WDW, June 2005
Polynesian, WDW Sept. 7 - Sept. 14, 2001
Caribbean Beach, June 1993

 Thread Tools Display Modes Rate This Thread Linear Mode Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Disney Trip Planning Forums     Welcome to the DIS     The DIS Unplugged Podcast         Power of 10 - DIS Events to Benefit GKTW         Podcast Cruises         DIS Adventures by Disney Trips     Theme Parks Attractions and Strategies         Doing the Happy Dance!         Disney Promotions and Celebrations--Current Promotion: Limited Time Magic         Theme Parks Community     Disney Resorts         Disney Discount Codes and Rates         Countdowns and Live Reports         Resort Community Threads & Photo-Video     Disney Restaurants         Disney Dining Reservations         Disney Dining Plan         Disney Dining Reviews     Orlando Hotels and Attractions         Hotel & Accommodations Reviews     Adventures By Disney     Disney Trip Reports         Pre-Trip Reports and Plans         Completed Trip Reports     Budget Board     Disney Rumors and News     Disney for Families         DIS Dads     Disney for Adults and Solo Travelers     The College Board     Teen Disney         Teen Board Birthdays and Celebrations     Gay and Lesbian at Disney     Disney World Tips     Transportation     disABILITIES!         disABILITIES Community Board     Camping at Disney World         Camping Community Board     Disney Weddings and Honeymoons         Planning our Happily Ever After             Completed trip reports and planning journals     DIS en Español Disney Vacation Club     Purchasing DVC     DVC Member Services     DVC Resorts     DVC-Mousecellaneous     DVC Trip Reports Global Neighbours     UK Trip Planning Forum     UK Community Board     UK DVC Discussion     UK Trip Reports Board     Canadian Trip Planning & Community Board     Disneyland Paris Trip Planning & Community Board         Disneyland Paris Trip Reports Board     Other Lands         Australia         Tokyo Disneyland         Hong Kong Disneyland Disney Cruise Line     Disney Cruise Line Forum         Disney Cruise Meets         Disney Cruise Line Trip Reports             Disney Cruise Line Pre-Trip Reports Royal Caribbean     Royal Caribbean Disneyland     Disneyland (California)         Southern California Theme Parks         Disneyland Community Board     California & the West         Southern California         Las Vegas     Disneyland Trip Reports         California & the West Trip Reports Universal Studios/Sea World     Universal Studios/Islands of Adventure Forums     Universal Orlando Resorts & Hotels     Universal Studios Trip Reports     Sea World / Discovery Cove Just for Fun     Community Board         Congratulations & Birthday Wishes         Games         Exchanges         United We Stand     Disney Movies, Books, TV and Music     Photography Board     Disney Online Games         Non-Disney Online Games         Virtual Traders Market         Online Gaming Community Board         Virtual Magic Kingdom (VMK) Museum             VMK Creations     In Memoriam     Dis Meets     The Creative Community         Arts and Crafts         Cooking         Flower & Garden Forum         Home Interior         Virtual Scrapbook         Scrapbooking         Swaps     W.I.S.H         Eating Healthy         Events/Competition         WISH Journals     Coping and Compassion     Just Say Thanks     Disney Rewards Programs     Disney Collectors Board         Trades/Wants Board     Creative DISigns     Disney Cast Members Technical Support     Technical Support         Test Board

 GET OUR DIS UPDATES DELIVERED BY EMAIL

 -- Default ---- DIS Unplugged ---- Disneyland ---- Disney Cruise Line ---- Universal Orlando ---- Disney Vacation Club ---- FLTOURS Transportation ---- Swan & Dolphin Resort ---- Adventures by Disney ---- Holidays ------ Holidays Light Contact Us - www.DISboards.com - Archive - Privacy Statement - Top

All times are GMT -5. The time now is 12:44 AM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

Copyright © 1997-2014, Werner Technologies, LLC. All Rights Reserved.