View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default Major and minor gridlines on logarithmic axis excel 2007

Please give as about six data points to try
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Vincent" wrote in message
...
In excel 2007 all service packs.

Create a scatter plot with data greater than 1E13.
Select logarithmic axis with any base (such as 10)
Choose major and minor gridlines.

When the data is large ( 1e13) only major gridlines show up. Minor
gridlines only does work, but not major *and* minor.

Are their any solutions?

It's almost impossible to read a log plot without minor gridlines, and
it's
important to highly the major lines as well with a dark line. Log plots
are
essential in any engineering or scientific plotting.

Excel is slowly and painfully becoming quite standard for this type of
plotting.