i've got some data that i want to display on a semi log graph, but i want to
change the x-axis to a log scale, not the y-axis. How do i do this?
anne
Anne:
Double click any value on your x axis, this will bring up Axis format form.
Select scale tab, check Logarithmic checkbox. Make sure that your minimum
value is 1, 10, 100, and your major amp; minor units must be multiples of 10.
...Kelly
quot;annequot; gt; wrote in message
...
gt; i've got some data that i want to display on a semi log graph, but i want
gt; to
gt; change the x-axis to a log scale, not the y-axis. How do i do this?
gt; anne
That's great, thanks
anne
quot;Kelly O'Dayquot; wrote:
gt; Anne:
gt;
gt; Double click any value on your x axis, this will bring up Axis format form.
gt;
gt; Select scale tab, check Logarithmic checkbox. Make sure that your minimum
gt; value is 1, 10, 100, and your major amp; minor units must be multiples of 10.
gt;
gt; ...Kelly
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt; quot;annequot; gt; wrote in message
gt; ...
gt; gt; i've got some data that i want to display on a semi log graph, but i want
gt; gt; to
gt; gt; change the x-axis to a log scale, not the y-axis. How do i do this?
gt; gt; anne
gt;
gt;
gt;
Make sure you create (or change to) a XY Scatter chart. Now, double-click
the x-axis and in the resulting dialog box, select the Scale tab. The last
step should be self-evident. {grin}
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article gt;,says...
gt; i've got some data that i want to display on a semi log graph, but i want to
gt; change the x-axis to a log scale, not the y-axis. How do i do this?
gt; anne
gt;
- Sep 29 Fri 2006 20:09
how do i change the x-axis of a graph to a log scale?
close
全站熱搜
留言列表
發表留言