This is on one of the threads, but I thought I would put it out to
everyone:

I've been told it's possible to make a chart of chart type line with
just the dots (no line or lines connecting them) by doing:

1. Create a line chart.
2. Select the line (click on it making sure the line has the focus).
3. Right click on the line and select Format Data Series
4. Under the pattern tab and the line section, select the None radio
button.
5. Click OK and you should have a line chart.

It works great, but the only thing is I have 200+ charts and growing. I
made these charts through the pivot chart function. Is there some
easier way to convert all the charts to just dots without having to go
into each one individually.

I've been following some of the recent threads on charts and saw that
Debra Daiglish has written a macro to print pivot charts. That would be
perfect! But is there some way to make it work for chart of chart type
line with just the dots.

Any solutions would be great. Thanks.

Dan


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!