Gridlines on Column Chart

S

SeanF74

Hello-

I am trying to create a stacked column chart with gridlines that only appear
for every 2 columns. How can I do this in Excel 2007? All I can find is how
to insert a major gridline between every column.

Thanks,

Sean
 
A

Andy Pope

Hi,

Format the X axis, on the Axis Options section set 'Interval between
tickmarks' to 2.

Cheers
Andy
 
S

SeanF74

That did not work. The major grid lines running from the X axis are still
running between each column.

-Sean
 
S

SeanF74

Thanks andy.

I didn't specify in the first post, but it is a stacked column chart created
as a pivot chart. This may be why it is not working for me.

-Sean
 
A

Andy Pope

Principle still works on a PivotChart. Unless you have more than 1 variable
on the Axis Field OR you have the data table displayed.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 line chart, can't make some gridlines heavier than others 10
Filtered view of Visio Chart 0
Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
bar chart prints 1 unwanted horizontal row of dots & tick marks? 0
Major gridlines - worked great on Excel 2003 but not 2007 0
Can you alternate background colors by gridline? 1
chart gridlines 1

Top