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
maroulatorAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
FlysterConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.