|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 15th, 2009, 08:15 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Gridlines on Column Chart
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 
|
|
#2
September 16th, 2009, 08:57 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Gridlines on Column Chart
Hi,
Format the X axis, on the Axis Options section set 'Interval between tickmarks' to 2. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SeanF74" wrote in message ... 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
|
|
#3
September 16th, 2009, 05:09 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Gridlines on Column Chart
That did not work. The major grid lines running from the X axis are still
running between each column. -Sean "Andy Pope" wrote: Hi, Format the X axis, on the Axis Options section set 'Interval between tickmarks' to 2. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SeanF74" wrote in message ... 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
|
|
#4
September 17th, 2009, 09:26 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Gridlines on Column Chart
It worked for me.
http://www.andypope.info/ngs/ng61.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SeanF74" wrote in message ... That did not work. The major grid lines running from the X axis are still running between each column. -Sean "Andy Pope" wrote: Hi, Format the X axis, on the Axis Options section set 'Interval between tickmarks' to 2. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SeanF74" wrote in message ... 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
|
|
#5
September 17th, 2009, 01:27 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Gridlines on Column Chart
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 "Andy Pope" wrote: It worked for me. http://www.andypope.info/ngs/ng61.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SeanF74" wrote in message ... That did not work. The major grid lines running from the X axis are still running between each column. -Sean "Andy Pope" wrote: Hi, Format the X axis, on the Axis Options section set 'Interval between tickmarks' to 2. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SeanF74" wrote in message ... 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
|
|
#6
September 17th, 2009, 01:38 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Gridlines on Column Chart
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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SeanF74" wrote in message ... 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 "Andy Pope" wrote: It worked for me. http://www.andypope.info/ngs/ng61.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SeanF74" wrote in message ... That did not work. The major grid lines running from the X axis are still running between each column. -Sean "Andy Pope" wrote: Hi, Format the X axis, on the Axis Options section set 'Interval between tickmarks' to 2. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SeanF74" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
