Post reply

Need same Bar color and line color

  • February 7, 2012 at 11:42 pm

    #255280

    Hello,

    I have around 50 products (parameter),the actual sales is represented in bar and goal is represented in line.when i select one or more product namethe bar(actuals) and goal(line) are comming in different colours.

    my requirement is if i select product1 the line and bar

    for product 1 shd be same colour

    say, for prod1 line and bar should be red

    prod2 line and bar should be blue

    prod3 line and bar should be green

    as of now i have more than 50 product.

    in property-->fill-->solid-->automatic is given.

    Thanks in Advance

    Nithila

  • February 8, 2012 at 12:31 am

    #1444309

    If you change the property from automatic to a color, doesn't it work?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 8, 2012 at 1:04 am

    #1444317

    Instead of automatic if i select blue all the bar and all line were in blue.

    i just want the lines have a similar color to the bars values.

    Product 1--Bar(actual) and line(goal) in blue

    Product 2--Bar(actual) and line(goal) in red

    like wise i have more than 50 product, it may increase

    so i don't want to hard code colors for each product..

    Thanks,

    Nithila

  • February 8, 2012 at 1:44 am

    #1444326

    A colleague of mine pointed me to this very interesting article (it's his article :-)):

    Pie Chart Techniques

    [/url]

    OK, it is about Pie Charts, but it is applicable to bars and lines. Go to the section about custom coloring. --> Create a custom palette and add custom colors.

    I've tested it with 2 series: sales and quote for each gender. So I have sales and quota for males and sales and quota for females.

    I added two times the color red and two times the color blue. See the attachment for the result.

    This probably means you'll need to add 50 colors 2 times, but hey, no pain no gain 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 8, 2012 at 4:43 am

    #1444420

    Thanks for the reply..

    I have two series for Y axis value

    i.Actual

    ii.Goal

    X-axis is month

    So when i change the series property of actual all the bar will be of same

    color,this apply to line as well.

    even i can try iif statement in expression since there is certain limit in the

    count of using iif.

  • February 8, 2012 at 4:55 am

    #1444426

    nithila.sp (2/8/2012)

    Thanks for the reply..

    I have two series for Y axis value

    i.Actual

    ii.Goal

    X-axis is month

    So when i change the series property of actual all the bar will be of same

    color,this apply to line as well.

    even i can try iif statement in expression since there is certain limit in the

    count of using iif.

    Did you try the custom color palette?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 8, 2012 at 11:05 pm

    #1444869

    Thank you ...it's working..

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply