A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Displaying dashed or dotted lines correctly in logarithmic scale?



 
 
Thread Tools Display Modes
  #1  
Old July 18th, 2007, 07:44 AM posted to microsoft.public.excel.charting
jure@geo
external usenet poster
 
Posts: 1
Default Displaying dashed or dotted lines correctly in logarithmic scale?

I'm observing a problem already described in Article 214389 (regarding
tredlines in Excel2000 displayed incorrectly).
I'm unable to print dashed or dotted lines in logarithmic scale correctly,
even though they appear correctly on screen and in print preview (!). A
dashed or dotted line does not appear to have any dashes, or only a portion
of the line may have dashes, or the dashed line appears to be distorted, or
of uneven spacing.

I guess it's an unresolved bug. I'm only surprised it's been known since
Excel2000, and not corrected!

Are there any solutions to the problem?
  #2  
Old July 18th, 2007, 12:38 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Displaying dashed or dotted lines correctly in logarithmic scale?

In general, I find the performance of dashed and dotted lines
unsatisfactory. Sometimes they don't render properly (as in your case) and
sometimes they are distracting when a different aspect of an illustration
should be emphasized.. Whenever possible I avoid using these lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"jure@geo" wrote in message
...
I'm observing a problem already described in Article 214389 (regarding
tredlines in Excel2000 displayed incorrectly).
I'm unable to print dashed or dotted lines in logarithmic scale correctly,
even though they appear correctly on screen and in print preview (!). A
dashed or dotted line does not appear to have any dashes, or only a
portion
of the line may have dashes, or the dashed line appears to be distorted,
or
of uneven spacing.

I guess it's an unresolved bug. I'm only surprised it's been known since
Excel2000, and not corrected!

Are there any solutions to the problem?



  #3  
Old July 18th, 2007, 07:07 PM posted to microsoft.public.excel.charting
Del Cotter
external usenet poster
 
Posts: 553
Default Displaying dashed or dotted lines correctly in logarithmic scale?

On Tue, 17 Jul 2007, in microsoft.public.excel.charting,
"jure@geo" said:

I'm observing a problem already described in Article 214389 (regarding
tredlines in Excel2000 displayed incorrectly).
I'm unable to print dashed or dotted lines in logarithmic scale correctly,
even though they appear correctly on screen and in print preview (!). A
dashed or dotted line does not appear to have any dashes, or only a portion
of the line may have dashes, or the dashed line appears to be distorted, or
of uneven spacing.

I guess it's an unresolved bug. I'm only surprised it's been known since
Excel2000, and not corrected!

Are there any solutions to the problem?


If you are trying to de-emphasize those lines, try leaving them solid,
but make them a lighter gray instead of black. I can't swear it will
work with Excel 2007, but give it a go.

One warning: in my experience, some color printers render all
hair-thickness lines as black, whatever color you set them to, so choose
the next thickness up if you want them gray. Sometimes a
single-thickness gray line turns out lighter than a hair-thickness black
line (although a hair-thickness gray line would be even lighter if the
printer honored it)

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:03 AM.


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