The Scale tab of the Format Axis dialog box. (If there is no Format Axis choice, then you did not right-click on an axis in step 1.) Excel displays the Format Axis dialog box. JavaScript / HTML5 charts and maps data-viz libraries for web sites and applications.
EDIT LINE GRAPH AXIS IN EXCEL FOR MAC HOW TO
How to make a single line graph in Excel. Right-click on the axis whose scale you want to change. On a line graph, the numerical value is always placed on the Y (vertical) axis, while the categories (e.g., days, months, years) are placed on the X (horizontal) axis.axis tick marks - the tiny lines that mark values and labels on a chart's axes. (The scale automatically chosen by Excel may not represent the entire universe of possibilities you want conveyed in your chart.) You can change the scale used by Excel by following these steps: FORMATTING CHART ELEMENTS SETTING DATA POINT SHAPES lai SETTING SCALE. Do any of the following: Set the line type: Click the disclosure arrow next to Major Gridlines or Minor Gridlines (in the Value tab), or Gridlines (in the Category tab), then click the pop-up menu and choose a line type. While Excel can automatically handle many of the mundane tasks associated with turning raw data into a chart, you may still want to change some elements of your chart.įor instance, you may want to change the scale Excel uses along an axis of your chart. In the Format sidebar, click the Axis tab, then choose Value (Y) or Category (X) for the axis you want to modify.
Excel includes an impressive graphing capability that can turn the dullest data into outstanding charts, complete with all sorts of whiz-bang do-dads to amaze your friends and confound your enemies.
0 kommentar(er)
