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