June 12, 2011 3:25 pm at 3:25 pm #597360KeepinEntertainedMember
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!June 12, 2011 7:45 pm at 7:45 pm #776141aries2756Participant
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.June 12, 2011 10:18 pm at 10:18 pm #776142individualMember
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!June 13, 2011 2:17 pm at 2:17 pm #776143veteranMember
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.
- You must be logged in to reply to this topic.