vaiable colours for selection in chart

[NoelH]

Hi
I have a chart (line) which uses looks at data on a state by state basis for
each quarter(year). If I look just at a single quarter there might be data
for 80% of the states, then when I look at the next quarter there might be
30% of the states with data. The workbook is available to be used over a
network. I'm trying to set the width of the lines to wider thinkness then the
standard, say 7 and not 3. As there are 6 graphs on a3 page and not 1 graph
per page.
The second is to stop the use of the yellow colour as it just washes out on
white paper.
Is there a way to solve this. I have tried the if/then but it just does not
seem to work So i'm moving back to square one.

Thanks in advance for any help.
Noel

 

[Turbo Turtle]

I'm trying to set the width of the lines to wider thinkness then the
standard, say 7 and not 3.

Do you want to write code to change the line thickness or are you having
trouble changing it manually ?

 

[NoelH]

Hi
write code to change the width
Thanks IA

Do you want to write code to change the line thickness or are you having
trouble changing it manually ?

 

[Jon Peltier]

In code you have the same choices as manually. But in code, you can also
draw a thicker line over the chart series:

http://peltiertech.com/Excel/Charts/VBAdraw.html

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

 

[NoelH]

Hi Jon

Thanks for the info
Noel

In code you have the same choices as manually. But in code, you can also
draw a thicker line over the chart series:

http://peltiertech.com/Excel/Charts/VBAdraw.html

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