In Excel 2000 line charts, the standard line styles are too limited
for my needs (and many of the broken line styles print badly on curved
lines). The minimum I need is a "dotted line style" where each element
is a circular dot (not a "dash" as in existing Excel styles), with
options about how large the dots are -- the equivalent of what Excel
offers with "dashed" lines, but with genuine circular "dots" instead
of "dashes". More options would be nice but not essential; I would be
happy to pay for some add-in if it exists.

---

Request for Question Clarification by maniac-ga on 04 Aug 2004 18:53 PDT

Hello Colemanhuff,

Hmm. Would you be willing to accept a macro that
 - plots your data as a plot w/o lines [or looks up an existing series]
 - adds a sheet with the "curved line dots" data points
 - adds the curved line dots as another series in the scatter plot
That would provide something that should look right (at least the plot
part). If that would be acceptable, please indicate in a question
clarification.

  --Maniac

---

Clarification of Question by colemanhuff-ga on 05 Aug 2004 16:32 PDT

Thank you for the suggestion, but I don't think it would work for me.
I need to have things in pretty standard form so I can cut and paste
into Adobe Illustrator and have things come through as normal graphics
elements (I do my final editing in Illustrator). If your work-around
would allow that, however, then it would then it would be fine. 
Regards, ColemanHuff.

try Mrexcel.com.  I find the community members there are Excel rock
stars...plus, it's free.

You can try vbaexpress.com too, where you'll find some really good VBA
coders, which would be required if you want to really automate it.