Help on logarithmic scale

  • Thread starter Thread starter pj_raesh
  • Start date Start date
P

pj_raesh

hi friends..,

I'm new to Excel development world and I got an assigment from our
company to redesing an excel worksheet with a chart. The 'X' axis
uses logarithmic scale and the value starts from 0.001. They need the
maximum value to end at 200. How can I design this. When I select the
major unit as 10 the 'X' axis values stops at 1000 after 100. Is there
anyway to stop the 'X' axis major unit at 200 while using the
logarithmic scale???

Thanking you,

Rajesh Joy
 
hi friends..,

I'm new to Excel development world and I got an assigment from our
company to redesing an excel worksheet with a chart. The 'X' axis
uses logarithmic scale and the value starts from 0.001. They need the
maximum value to end at 200. How can I design this. When I select the
major unit as 10 the 'X' axis values stops at 1000 after 100. Is there
anyway to stop the 'X' axis major unit at 200 while using the
logarithmic scale???
Click to expand...
Adapt the following that applies to the y axis:
Flexible Log Scale
http://www.tushar-mehta.com/excel/newsgroups/flexible_log_scale/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top