AJP Excel Information

Charts













 
 

Re: Gridlines on Column Chart

 
Use Axis Options 'Intervals creates a coloured section within a donut chart depending upon the month status value.
The valid values are R, A, G or blank.
Select X axis and display Format Axis dialog. Within the Axis Options tab use the 'Interval between tick marks:' to determine major gridline spacing.
 

ng61.zip (8kb)

 

 
 
 
   

Last updated 17th September 2009

 
 
  Home | Charts | VBA Code | Fun Stuff
Newsgroups | Tips | Links | What's New | Book List
Contact | About
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2009 Andy Pope