| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert superscripted value in Y-axis title of excel sheet | Charts and Charting in Excel | |||
| Incomplete Support for Unicode fonts for Excel 2000 embedded in Wo | Charts and Charting in Excel | |||
| Excel graph problem | Excel Discussion (Misc queries) | |||
| Plotting diagonal axis in Excel or rotating charts | Excel Discussion (Misc queries) | |||
| excel should make it easier to have a 1 to 1 plot area in chart | Charts and Charting in Excel | |||
Linear Mode
