Line Chart Color

CoderMike

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

merin

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.)

CoderMike

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

merin

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

CoderMike

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

merin

What you mean by dynamic series

CoderMike

I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.

Rev-ßoy

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

Re: Line Chart Color

Re: Line Chart Color

Re: Line Chart Color

Re: Line Chart Color

Re: Line Chart Color

Re: Line Chart Color

Re: Line Chart Color