By default, when creating a stacked area Pivot Chart, Excel 2013 does not include vertical gridlines. How can I enable them?
11 Answer
First, click the chart area. That will reveal the Chart Elements plus sign icon and the Chart Styles paintbrush icon. Click the Chart Elements icon. This should reveal a list of checkboxes for things like Axes, Axis Titles, etc. Ensure that the Gridlines checkbox is checked. Then, click on the right arrow icon next to Gridlines to reveal another list of checkboxes for things like Primary Major Horizontal, Primary Major Vertical, etc. Ensure that the appropriate vertical selections are checked.
This image should help:
See also:
