XY charts: Change formats of lines/symbols for multiple datasets

Hello

I have say 200 datasets... all in one xy chart. I use filter on the database to select a subset of the data to visualize the data I want.

The first 100 I would like to be solid lines, the last 100, dashed..

I used the VBA code below to have all weights the same.

Can this VBA code be modified to:

a) have a counter to do the first 100 graphs with solid lines and the next 100 graphs with dashed lines
b) is it possible to have the same VBA macro apply the same symbol for the first 100 and a different symbol for the next 100
c) change all symbols to have a black outline and change the size of all symbols ( I am picky about my symbols

Thanks in advance

A Canadane

Please Login or Register  to view this content.

Hello, bonjour,

Here's a small example that you can play with :

Please Login or Register  to view this content.

Hello,

Ok, see below. Code is slightly modified. I forgot that when usine the .Format.Line property, it applies to be the marker and the connecting line.
To only change the connecting line, you must use the .Border.LineStyle property.

As you can see in the code below, you can play with a couple parameters values to show the marker line or not...

Please Login or Register  to view this content.