Line Point chart

hi,
How can i change the color property of the line in the line chart.
For bar charts and all i go to series style and change it.
but for line chart, default comes to green - and i would like to change it
to red.
thanksFor line charts, you need to change the series style border line color
(instead of the color property).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ramani" <Ramani@.discussions.microsoft.com> wrote in message
news:8A2BA0F6-A412-40EC-A316-B9D5F9D44889@.microsoft.com...
> hi,
> How can i change the color property of the line in the line chart.
> For bar charts and all i go to series style and change it.
> but for line chart, default comes to green - and i would like to change it
> to red.
> thanks
>|||Hi All,
I have a line a line chart where there are 2 lines.one of the line seems to
be hidden im not sure y' only one line is displayed at a time...
Can any1 let me know of my problem,
Thanks,
"Robert Bruckner [MSFT]" wrote:
> For line charts, you need to change the series style border line color
> (instead of the color property).
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ramani" <Ramani@.discussions.microsoft.com> wrote in message
> news:8A2BA0F6-A412-40EC-A316-B9D5F9D44889@.microsoft.com...
> > hi,
> > How can i change the color property of the line in the line chart.
> > For bar charts and all i go to series style and change it.
> > but for line chart, default comes to green - and i would like to change it
> > to red.
> > thanks
> >
>
>

Line Chart Line Color

Is it possible to change line color in the line chart. I can change series
color in a bar chart, but cannot seem to change the color of the lines when
selecting a smooth line chart.
-ChrisThe relevant property in line charts is the border line color property.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Borgers" <ChrisBorgers@.discussions.microsoft.com> wrote in message
news:4852411A-7B54-4A8D-9E19-E3787F9D1656@.microsoft.com...
> Is it possible to change line color in the line chart. I can change
series
> color in a bar chart, but cannot seem to change the color of the lines
when
> selecting a smooth line chart.
> -Chris

Line Chart Color

Hello,

My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?

Michael

To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||

Merin,

I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?

Michael

|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||

Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.

Michael

|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.

i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).

however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x

(refer to code snippet)

and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.

rev-boy

=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)

Line Chart Color

Hello,

My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?

Michael

To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||

Merin,

I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?

Michael

|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||

Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.

Michael

|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.

i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).

however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x

(refer to code snippet)

and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.

rev-boy

=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)