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?

shogun5Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shogun5Author Commented:
Perfect, just what I needed. Thank you!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.