{"id":557,"date":"2013-10-14T12:44:14","date_gmt":"2013-10-14T17:44:14","guid":{"rendered":"http:\/\/www.cognitiveinfo.com\/?p=557"},"modified":"2013-10-14T12:44:14","modified_gmt":"2013-10-14T17:44:14","slug":"custom-chart-palettes-in-ssrs","status":"publish","type":"post","link":"http:\/\/cognitiveinfo.com\/?p=557","title":{"rendered":"Custom Chart Palettes in SSRS"},"content":{"rendered":"

\"SSRS<\/p>\n

This article is a follow up to the Cognos article on creating a custom color palette.\u00a0 <\/a><\/p>\n

Custom palettes are pretty common when companies start to standardize their corporate image across all company communications.<\/p>\n

    \n
  1. Make a copy of your report template.<\/li>\n
  2. Name it ‘MyCorp Chart Report’<\/li>\n
  3. In the report area, add a chart<\/li>\n
  4. Right-Click the chart object and choose Properties<\/li>\n
  5. For Palette, choose ‘Custom’\"SSRS-custom2\"
    \n<\/a><\/li>\n
  6. In the properties window, not find the custom palette settings.
    \n    \"SSRS-custom4\"<\/a><\/li>\n
  7. A dialog box appears that allows you to select each color to include in the custom palette.\u00a0\u00a0 Below I have set the first color in the palette using RGB codes to match the purple logo for Cognitive Information.\u00a0\u00a0 You can also click the elipses to use the color picker or color wheel.\"SSRS-custom5\"<\/a><\/li>\n
  8. Once you click ‘OK’ the new palette is applied to the sample chart.<\/li>\n<\/ol>\n

    If you change the chart type,\u00a0 it will keep the custom color palette.\u00a0\u00a0 If you copy the chart object, it will also keep the custom palette.<\/p>\n

    To copy your new custom palette to other charts and not loose more minutes of your life to the tedium of picking colors, go to the code view.<\/p>\n

    \"View<\/p>\n

    Search and find <ChartCustomPaletteColors>.   \nCopy the folowing section to other reports as needed.   \nThe code for the color palette above:<\/pre>\n
    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Palette>Custom<\/Palette>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ChartCustomPaletteColors>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ChartCustomPaletteColor>#43057a<\/ChartCustomPaletteColor>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ChartCustomPaletteColor>Yellow<\/ChartCustomPaletteColor>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ChartCustomPaletteColor>Plum<\/ChartCustomPaletteColor>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ChartCustomPaletteColor>Orange<\/ChartCustomPaletteColor>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ChartCustomPaletteColor>SlateBlue<\/ChartCustomPaletteColor>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ChartCustomPaletteColor>LightGreen<\/ChartCustomPaletteColor>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ChartCustomPaletteColor>HotPink<\/ChartCustomPaletteColor>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ChartCustomPaletteColor>Blue<\/ChartCustomPaletteColor>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ChartCustomPaletteColor>DarkGreen<\/ChartCustomPaletteColor>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/ChartCustomPaletteColors><\/pre>\n
    If this has been helpful, let me know.<\/p>\n
    References:<\/strong><\/p>\n
    http:\/\/technet.microsoft.com\/en-us\/library\/dd239399.aspx<\/a>
    \n    http:\/\/technet.microsoft.com\/en-us\/library\/dd239355.aspx<\/a><\/p>\n
    Update: This article got saved away as a ‘draft’ for way too long.\u00a0\u00a0 I updated both articles and I finally hit Publish.
    \n<\/em><\/p>\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
    This article is a follow up to the Cognos article on creating a custom color palette.\u00a0 Custom palettes are pretty common when companies start to standardize their corporate image across all company communications. Make a copy of your report template. Name it ‘MyCorp Chart Report’ In the report area, add a chart Right-Click the chart […]<\/p>\n","protected":false},"author":2,"featured_media":559,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[79,102],"class_list":["post-557","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ssrs","tag-reporting-services","tag-ssrs"],"_links":{"self":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/557","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=557"}],"version-history":[{"count":0,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/557\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=557"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}