Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
anne
 
Posts: n/a
Default how do i change the x-axis of a graph to a log scale?

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
  #2   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day
 
Posts: n/a
Default how do i change the x-axis of a graph to a log scale?

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 & minor units must be multiples of 10.

...Kelly







"anne" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.charting
anne
 
Posts: n/a
Default how do i change the x-axis of a graph to a log scale?

That's great, thanks
anne

"Kelly O'Day" wrote:

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 & minor units must be multiples of 10.

...Kelly







"anne" wrote in message
...
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




  #4   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default how do i change the x-axis of a graph to a log scale?

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 ,
says...
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the axis in excel to the american style Hoquista Charts and Charting in Excel 4 July 28th 09 03:02 PM
Changing the scale major unit in a graph Ant Excel Discussion (Misc queries) 2 February 6th 06 01:42 PM
X-Y Graph with Months, Not Date on Axis Sam Fertel Excel Discussion (Misc queries) 1 January 10th 06 04:15 AM
How to specify values for X axis in a Graph Pankaj Charts and Charting in Excel 1 September 27th 05 05:06 PM
How do I change the scale of the catagory axis? amcmaster Charts and Charting in Excel 1 March 2nd 05 04:46 PM


All times are GMT +1. The time now is 07:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"