Microsoft Excel Help!

Home Forums Computers / Electronics / Online Microsoft Excel Help!

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #597360

    G’Afternoon!

    Please help me with microsoft excel! I need to make a graph for a report with days (day 1,2,3,4…) along the X axis and exact time (1:00, 1:30,2:00) in chronological order along the Y axis.

    Please advise as to how I can do this!

    I made a column on my computer with the days listed and with the time listed but it wont graph properly!

    Thank you!

    #776141
    aries2756
    Participant

    There are functions in Excel for charting and graphing. Just entering info in the spreadsheet does not complete the process. I don’t know which version you have and which processing system. So go into the help mode and search for charting or graphing whichever you are looking for and follow the instructions.

    #776142
    individual
    Member

    type in 1, 2, 3, in seperate cells. Highlight the three, and run your mouse over the right hand corner (where the small square is, you’ll get a plus sign, and drag it. All the numbers will populate. You can do the same thing for the time, just type atleast 2 times on the y axis. Best of luck!

    #776143
    veteran
    Member

    Different versions of Excel create charts differently, but I can give you a general idea of how to do it.

    1) Build a table. If you want to graph something by days and hours, then your table should be rows of days and columns of hours. Insert your data points in the table accordingly.

    2) In the toolbar, select “Insert -> Chart”. If you are in 2007 or 2010 there are menu buttons for different types of charts in the toolbar. Either way, this will bring you to a wizard. For data source, select the entire table you created in step 1. This will create the graph/chart

    3) Select an empty point inside the graph and right-click. This will bring up an editing menu for the graph, where you can set things such as axis labels, increments, titles, etc.

    Click around a bit until you find exactly what you need or use Excel help (F1). If you ask for help here you need to get much more specific.

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.