vaiable colours for selection in chart
 

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

vaiable colours for selection in chart
 

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 ?

vaiable colours for selection in chart
 

Hi
write code to change the width
Thanks IA

"Turbo Turtle" wrote:


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 ?

vaiable colours for selection in chart
 

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 wrote:

Hi
write code to change the width
Thanks IA

"Turbo Turtle" wrote:


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 ?

vaiable colours for selection in chart
 

Hi Jon

Thanks for the info
Noel

"Jon Peltier" wrote:

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 wrote:

Hi
write code to change the width
Thanks IA

"Turbo Turtle" wrote:


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 ?