Apr 26, 2013

Change Chart line colour in SSRS 2008?


If you are a regular user of SSRS charts, you will know that charts use built-in predefined colour palettes. I will demonstrate this by using Line Charts which is already setup for our example. In the snapshot below, you can see that we have multiple lines each representing a series and has a unique colour. However, these colours were assigned by SSRS automatically. Some times the colours are too similar and would be hard to differentiate between them. So, it would be nice to change them with our own custom palette colours.
image
To do this, you have to be in Design mode in SSRS and follow the steps below:
1. Click once on the Chart to select its properties. Make sure that you have selected the Chart – a double click on the Chart will bring Chart Data properties rather than the Chart itself.

2. If you have selected by mistake Chart Data, you can switch to Chart properties by choosing Chart from the list of object names under Properties window box:
image

3. Under the Chart section in the Properties window, choose CustomPaletteColors and click on the botton to open the dialog window:
image

4. Add your custom colours that you like to create your own palettes. This site will help you to choose a colour scheme (http://www.colorschemer.com/schemes/index.php):
image

5. Finally, we can see that now our Chart is using the custom colours which we added rather than the predefined built-in colours:
image

8 comments:

  1. If you want to apply your own colors to the chart, use a custom palette. A custom palette let you add your own colors in the order you want them to appear on the chart Read more…

    Check this site Mindmajix for indepth MSBI Tutorials

    Go here if you’re looking for information on MSBI Blogs

    ReplyDelete
  2. Excellent post
    I love seeing websites....A custom palette let you add your own colors in the order want to appear on the chart and SQL SERVER TRAINING check this site and more information ....

    ReplyDelete
  3. Excellent piece of information, I had come to know about your website,i have read some posts of yours by now, and let me tell you, your site gives the best and the most interesting information. More Details About MSBI Click here.

    ReplyDelete

  4. Informative post indeed, I’ve being in and out reading posts regularly and I see alot of engaging people sharing things
    and majority of the shared information is very valuable and so, here’s my fine read.
    Java training in Chennai

    Java training in Bangalore

    Java training in Hyderabad

    Java Training in Coimbatore

    Java Online Training

    ReplyDelete

  5. Thank you for sharing such a really admire your post. Your post is great! . micronutrients fertilizer for plants

    ReplyDelete

Hi,

Thanks for your visit to this blog.
We would be happy with your Queries/Suggestions.