Welcome toExcel2007.Tips.Net
Helpful Links
Beauty Tips
ExcelTips
Legal Tips
Pet Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Controlling Gridlines on Charts
Summary: When Excel creates a chart for you, it may include gridlines that appear being the data series. If you don't like these gridlines or if you want to change how they appear, you can easily do so.When you create a chart from your Excel data, the Chart Wizard takes care of many of the actual details related to how a specific chart appears. One of the elements that can be included on many of the charts is gridlines. Gridlines are helpful for easily determining the height or width of graphic elements used in your chart.
Excel allows you to specifically control which gridlines are displayed, or if they are displayed at all. You can do so by following these steps:
- Select the chart by clicking on it. You should see selection handles appear around the outside of the chart.
- Make sure that the Layout tab of the Ribbon is displayed. (This tab is only visible when you've selected the chart in step 1.)
- Click the Gridlines tool in the Axes group. You'll see a drop-down menu appear with various options.
- Use the Primary Horizontal Gridlines option or the Primary Vertical Gridlines option to make changes to the gridlines, as desired.
Related Tips:
Create Rock-Solid Lists! Bulleted and numbered lists can help make your writing clearer and easier to follow. If not done properly, however, they can be a nightmare to work with. Discover the ins and outs of Word's lists with this great reference available in two versions. Check out Word Bullets and Numbering today!