Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |