Friday, December 16, 2011

How to Make a Graph on Excel With Intervals of 0.5


1. Open the Excel 2010 spreadsheet file that contains the data you want to make into a graph.
2. Click on any cell within the data field that you want to use in your graph, then click the 'Insert' tab at the top of the window. Click on your desired chart type from the Charts area of the ribbon, then click on the specific chart that you wish to create. Excel will place the chart in the middle of your spreadsheet.
3. Click on any of the white space in the chart to select the entire chart, then click the 'Layout' tab at the top of the screen. Click the drop-down box on the left end of the ribbon and choose 'Vertical (Value) Axis.' If you have created an XY Scatter chart and want to modify the horizontal axis, you can instead choose 'Horizontal (Value) Axis.' Click the 'Format Selection' button, located just below the drop-down box, to open the Format Axis window.
4. Select the 'Fixed' radio button next to 'Major Unit' on the right side of the window. Place your cursor into the text box to the right of this radio button and type '0.5' into the box.
5. Click 'Close' to close the window and see your new axis on the chart.

Blogger news