Results 1 to 4 of 4

Thread: Converting a whole chart from Megawatts to Gigawatts

  1. #1

    Converting a whole chart from Megawatts to Gigawatts



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, I have a chart where I'd like to split every number by 100, to give me i in Gigawatts instead of megawatts. Can it be done?

    1979 14700 15400 25600 14300 18100 10800 6860 13100 19400 13200 18800 20300
    1980 15600 10500 18900 10900 11000 9170 6790 9750 14200 20600 17100 23400
    1981 22100 15200 14900 13000 14900 13700 10300 12600 13400 15100 21200 19300
    1982 15700 10600 20600 14600 16500 7590 8420 14900 19800 18800 22700 22500
    1983 26800 16600 17700 13100 16400 11900 11000 10700 19800 25700 20200 24500
    1984 22600 11700 17700 15200 14300 12800 8930 8420 11100 23000 19900 17800
    1985 15400 9090 19400 17300 11800 5140 9830 17600 17200 17600 16500 14000
    1986 19800 12700 20900 12300 19600 9800 11700 12500 16700 19800 25400 24500
    1987 18500 15100 11900 15500 13800 11000 11500 10000 16200 21400 12300 18700
    1988 22800 20500 16300 13700 9350 5580 14400 11200 19500 16200 20000 21600
    1989 29000 24500 19600 15900 16300 10500 10700 13200 12100 16700 15900 16900
    1990 24200 24500 28700 18200 11600 9410 16800 12700 16300 18200 12600 21500
    1991 18600 20400 13400 16800 17100 13200 7140 9080 18300 14000 20800 22600
    1992 22400 21100 20200 15200 14700 10200 13100 17400 12700 16400 19900 20500
    1993 29800 17000 20100 14500 11400 7520 12200 13200 15100 18500 14900 21900
    1994 19600 11400 23600 17800 10700 17400 6780 11500 16300 18400 17300 20700
    1995 22900 22900 22600 16100 13800 11700 13900 11700 20200 22600 16500 10600
    1996 10800 16200 15000 10700 14600 12300 14200 14500 12400 18600 19800 18600
    1997 17300 25300 21900 18500 12400 8770 5620 8570 16900 19200 12900 12700
    1998 19800 22800 17100 15100 10900 12300 9410 16500 13200 18200 10500 22400
    1999 18600 16600 20300 15500 16800 14200 11000 8840 14800 18900 20900 23700
    2000 23300 18900 19300 13700 13200 16200 8630 9940 16000 19000 20600 16100
    2001 14300 18200 12700 13900 13200 10600 9780 13200 13900 18900 24200 17200
    2002 21000 21300 21400 11200 14700 12300 10100 6390 10300 18100 16700 16000
    2003 21300 9150 16500 16900 14500 10100 7820 11800 16500 13500 13300 22100
    2004 17500 16200 17100 14600 14400 11600 8440 14200 17900 19100 19400 21700
    2005 25400 18800 11100 14000 12900 11300 8370 10900 18300 17000 20300 23400
    2006 17900 15100 14600 13600 12000 11700 9090 8460 14700 13800 23600 25200
    2007 23600 18000 17600 14800 17200 9640 13800 15400 20600 13700 19100 16900
    2008 27900 22300 19700 11100 6700 13100 9690 12400 12400 22800 19100 14200
    2009 20400 7170 16400 11300 13800 10300 12700 14300 19400 14500 22000 13700
    2010 13300 11300 15800 12600 9690 7480 14000 12800 16200 18200 21900 15500
    2011 19200 19700 22300 14400 16200 11800 9720 12200 18700 21700 13600 24500
    2012 19000 17600 21500 14500 12400 10700 11600 9380 21200 17400 24200 19600
    2013 15700 11000 14600 17300 19800 11300 10100

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Do you mean 1000?

    Anyway enter 100 (or 1000) in any blank cell and copy it.

    Then select your range to convert, then right-click Paste Special, and select Divide from the Operation section, click Ok. Now you can delete the 100 in the separate cell.


  3. #3
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    183
    Articles
    0
    Excel Version
    2010
    You can also change the number format for the chart axis (or data labels).
    Circumference of a circle = 2πr²



    ²the circle's radius

  4. #4
    Thanx, that did the trick!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •