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

> 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 ?

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 ?

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 ?

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 ?
>