vaiable colours for selection in chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I'm trying to set the width of the lines to wider thinkness then the
standard, say 7 and not 3.
Click to expand...

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

Turbo Turtle said:
Do you want to write code to change the line thickness or are you having
trouble changing it manually ?
Click to expand...
 
Back
Top