Excel X Axis and square Grid
Hi can anyone help with these two questions.
Windows 2000. Office 2002. Chart in Excel Question 1. When Y cooridinate is negative want X axis labels at bottom of chart and not along the Y = 0 axis. Question 2. Is there any way of automatically adjusting the max X and Y coordinates so that the distance between grid lines have the same value so that the grids appear square. |
Excel X Axis and square Grid
Hi,
Double click the x axis and on the patterns tab set the tickmark labels to low. See this for square grid. http://peltiertech.com/Excel/Charts/SquareGrid.html Cheers Andy FGM wrote: Hi can anyone help with these two questions. Windows 2000. Office 2002. Chart in Excel Question 1. When Y cooridinate is negative want X axis labels at bottom of chart and not along the Y = 0 axis. Question 2. Is there any way of automatically adjusting the max X and Y coordinates so that the distance between grid lines have the same value so that the grids appear square. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 02:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com