Written by Allen Wyatt (last updated November 20, 2021)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
When you create a chart from your data, Excel automatically 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 any are displayed at all. You can do so by following these steps if you are using Excel 2007 or Excel 2010:
You can't use the above steps in later versions of Excel because Microsoft decided, in their wisdom, to remove the Layout tab entirely. Instead, you can control the gridlines by following these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9902) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Excel here: Controlling Chart Gridlines.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
When sending a chart to someone else, it can be frustrating for the other person to open the workbook and see errors ...
Discover MoreOnce you create a chart, you aren't limited to keeping the data series in the order they originally appeared. You can ...
Discover MoreExcel provides quite a bit of flexibility in how your chart looks. One of the least flexible places is in adjusting the ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments