P
Puppet_Sock
This is from Excel 2007. Don't know what happens in other versions.
Put the following data on some cells
x y1 y2
1 1.00E+19 2.00E+02
2 1.00E+19 2.00E+02
3 1.00E+19 2.00E+02
Select it. Move to the Insert tab on the ribbion. Insert a scatter
plot
of this data. Click the button on the ribbon that switches row-column.
(That's the first encounter of somebody who left the seat down
in a Men's washroom. But never mind.)
Now right click on the vertical axis, select Format Axis, and change
the axis to Logarithmic.
Note the missing horizontal grid lines at 1E2 and 1E4.
Can anybody tell me how to have those grid lines visible? It makes
my graph look stupid.
Socks
Put the following data on some cells
x y1 y2
1 1.00E+19 2.00E+02
2 1.00E+19 2.00E+02
3 1.00E+19 2.00E+02
Select it. Move to the Insert tab on the ribbion. Insert a scatter
plot
of this data. Click the button on the ribbon that switches row-column.
(That's the first encounter of somebody who left the seat down
in a Men's washroom. But never mind.)
Now right click on the vertical axis, select Format Axis, and change
the axis to Logarithmic.
Note the missing horizontal grid lines at 1E2 and 1E4.
Can anybody tell me how to have those grid lines visible? It makes
my graph look stupid.
Socks