+ Reply to Thread
Results 1 to 2 of 2

Newbie needs help on making a bar chart!

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Red face Newbie needs help on making a bar chart!

    I am confused with how to make a chart with the given information:
    Travel Characteristics for Indiana and the United States: 2003 and 2013

    Indiana United States
    2003 2013 Percent change 2003 2013 Percent change
    People who live in area
    Percent traveling households 72.3 81.2 12.3% 80.1 89 11.1%
    Trips per household 4 5 25.0% 4.5 6.1 35.6%
    Trips per traveling household 6 6.8 13.3% 6.4 7.7 20.3%

    Trips per capita 2.4 4.3 79.2% 2.7 4.4 63.0%
    Trips per traveler 2.6 4.7 80.8% 4.4 5.4 22.7%
    Miles per traveler 1688.6 3,246 92.2% 3,155 4,386 39.0%
    Miles per trip 469.5 762 62.3% 788.7 920 16.6%

    People who visit area
    Trips per traveler 4.2 5.5 31.0% 4.4 5.4 22.7%
    Miles per traveler 2,183 3,114 42.7% 3,155 4,386 39.0%
    Miles per trip 579.6 637.4 10.0% 788.7 920 16.6%


    I need to create a bar chart to illustrate the differences in Trips Per Traveler and Miles Per Traveler of the average Indiana resident, the average US resident, and the average Indiana visitor. Every time I try to make a chart it comes out jumbled and doesn't look right. Can anyone do a step by step for me? I'd be very grateful!

  2. #2
    Registered User
    Join Date
    09-22-2012
    Location
    Belfast
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Newbie needs help on making a bar chart!

    You could try and restate the question, frankly i cant make head or tail of it.

+ 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