More Tutorials Video: Change Pivot Chart Number Format Customizing background color and grid lines.Macro -Change Number Format All Pivot Charts Grid lines can be altered by selecting your preferred “Line Color” and “Line Style”, also under the “Home” menu.Įxample. To modify graph paper background, select the area and use the “Fill Color” option, under the “Home” menu to charge the color of the grid. Grid lines and graph paper color can be jazzed up just the way you like it. You would need to re-adjust the labels and lines to fit the new grid scale. Note: Modifying the grid scale will displace the originally configured lines and labeling. Then, modify the “Row Height” to create a perfect square by repeating this step on rows. This allows you to manually enter the new scale requirement. Select the entire area, right click on any row and select “Column Width”. But what if you need to work in a ½ inch grid scale? You can! First, check to ensure that you are in “Page Layout” view. Modify Grid ScaleĪs mentioned, this template comes standard with a ¼ inch grid scale. Note: Another way to create new labeling is to create a new image with new increments (similar to what was originally included in the template), paste the image along the axis, and adjust image to fit the grid scale. Deleting original graphic labelingĮxample. You can modify the increments by, first, deleting the original numerical graphic, and then manually re-labeling the X and Y axis using your preferred increments.Įxample. But let’s say you prefer to work in increments of 5. This template has numerical labeling in increments of +1 and -1, which are not entered manually, but instead applied as a graphic, which is great if you are looking for a quick printout. A line chart with plot points created using “Insert” menu. There! You have ready-to-print, line chart, without lifting a pencil.Įxample. Next, use the same menu to insert a line to link the coordinates. To plot coordinates, pick a shape from the “Insert” menu to represent each coordinate and then use the labeled axis to plot out each coordinate. One of the easiest ways to use this grid in Excel is to create a line chart. This gives you the option to include a line or a shape with greater precision by using the graph.Įxample. To use linear objects, select “Illustrations”, and then select “Shapes”, under the “Insert” menu. For example, linear objects can be inserted to help with plots and drawings. You may also choose to work with the graph paper in Excel. If these configurations are exactly what you’re looking for and you want to draw by hand, just hit print - each tab is configured to print in its appropriate orientation type. Use the header to include information, such as name and date. Make it your own - personalize! Each worksheet has a built-in header. Ideal for equations and coordinates with larger positive values. This grid is in landscape orientation (for larger X-axis values). 25 inch scale, single axis, and numeric labels in increments of +1. This grid is in portrait orientation (for larger Y-axis values). Ideal for equations and coordinates with positive and negative values. 25 inch scale, 4-quadrant axis, and numeric labels in increments of +1 and -1. Here is a list of all worksheets included in this template. You may choose to work with a 4-quadrant axis or single axis grid, in either portrait or landscape orientation. This template contains multiple worksheets. The Coordinate Graph Paper Template is a type of cartesian graph paper template, which is very useful because it allows you to draw straight lines and other objects, with precision and ease.