• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2301
  • Last Modified:

changing the bar chart color

Hello Experts,

Up to this point I have been forced to accept the default bar chart colors in SQL Server 2005 Reporting Services. Is there any way to force my own colors?

0
shogun5
Asked:
shogun5
  • 4
  • 2
1 Solution
 
Ashok KumarCommented:
You can acheive this by setting the colors by using Appearance/Series style and fill colors, for the value plot.
0
 
brejkCommented:
Yes. In Visual Studio in Report Designer right-click the chart placed on your report. Go to Properties. Then click on Data tab. I you have any values there click Edit... Then go to Appearance tab and click Series Style... There you can find Fill tab which contains settings you are looking for.
0
 
Ashok KumarCommented:
Right click on your chart, go to data tab, select the "Values" , go to appearance tab, click on series style, select fill color. from here you can customise your own colors that are to be used by the chart. for series fill colors
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
shogun5Author Commented:
SOTGarmentsIndiaPrivateLimited,

If I do this I can change the color but this affects all series. For example if I set light blue then all my bars are light blue and this does help me to differentiate between the series. The auto setting will set a different color to each series. I have three different category fields and I would like to specify a differenct color for each.
0
 
Ashok KumarCommented:
You can use expressions for the fill color field, iif(Fields!category.value=xx,'RED',...)
0
 
Ashok KumarCommented:
0
 
shogun5Author Commented:
Perfect, just what I needed. Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now