![]() By now, you might have already figured out how to do this. Now comes the fun and easy part: naming your graph. You can choose to sort based on smallest to largest or largest to smallest, depending on your preference. To do this, highlight all of your data in the cells above your chart, click ‘Data,’ and select ‘Sort,’ as shown below. If you have more than two lines of data to adjust, you can also rearrange them in ascending or descending order. This time, click the up and down arrows, as shown below, to reverse the order of your data on the chart. To sort the data so the respondents’ answers appear in reverse order, right-click on your graph and click ‘Select Data’ to reveal the same options window you called up in Step 3 above. ![]() Here, you can decide if you want to display units located on the Axis Options tab, or if you want to change whether the Y axis shows percentages to 2 decimal places or to 0 decimal places. To change the type of measurement shown on the Y axis, click on the Y axis percentages in your chart to reveal the ‘Format Axis’ window. When you first make a graph in Excel, the size of your axis and legend labels might be a bit small, depending on the type of graph or chart you choose (bar, pie, line, etc.). Here, you can choose which layout you prefer for the chart title, axis titles, and legend. To change the layout of the labeling and legend, click on the bar graph, then click the ‘Chart Design’ tab. When you’re finished, click ‘OK’ at the bottom. If you want to switch what appears on the X and Y axis, right-click on the bar graph, click ‘Select Data,’ and click ‘Switch Row/Column.’ This will rearrange which axes carry which pieces of data in the list shown below. Choose the graph you wish from the dropdown window that appears. Then, go to the ‘Insert’ tab, and in the charts section, click the column icon. To make a bar graph, highlight the data and include the titles of the X and Y axis. The data I’m working with will look best in a bar graph, so let’s make that one. This includes column (or bar) graphs, line graphs, pie graphs, scatter plot, and more. In Excel, you have plenty of choices for charts and graphs to create.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |