• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

Excel Graphing

To whom it may concern,

I am trying to achieve the gridline depicted in the first slide of the attached deck (I want to keep the graph as a line-chart) and was wondering if there is a setting in Excel that will allow me to do it automatically. If this doesn't work, is there an automated way to achieve the gridline depicted in the second slide of the attached deck (as a second-best solution)?

Right now, you will notice that my vertical lines have been entered manually making for a sloppy graph. In addition, I am hoping to put together about 60 similar graphs, making for an extremely tedious manual process.

Any thoughts?

Thanks in advance,

-Maroulator
Example.pptx
0
maroulator
Asked:
maroulator
1 Solution
 
FlysterCommented:
Highlight the chart. This will bring up the Chart Tool on the ribbon. Select the Layout tab. Under Axes select Gridlines. You select and format the gridlines from there.

Flyster
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now