View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Log scale and minor gridline labels

Hi,

I am not clear on the second question - you want to display a portion of the
Y-axis, but what does changeing the X-axis have to do with it?

Normally if you only want to see a portion of the Y axis you would right
click the Y-axis and choose Format Axis, pick the scale tab and change the
Minimum and Maximum values.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dgilbey" wrote:

I am trying to plot pH data in a scatter chart. I need to need to use log
scale for yaxis but cannot seem to figure out how to do the following.

1. cannot display minor gridline labels (since this is log scale...using
range of 1-10) how do I get the minor labels to appear?

2. how do I just show a subsection of this y-axis range without placing the
x-axis in the middle of the chart? for example, if I set the x axis to cross
at 5...then I still have the portion of the chart below 5 showing.