Formatting the chart color in excel 2010 is not working

[Eshwararao]

Hi,

I have created an excel dashboard where we will have to show sales of products, the data is coming from a SSAS cube.

I have to show one particular product sales in blue color remaining in grey color i have to do this without using VBA code. I have manually changed that product color as blue remaining as grey but when this is not working properly for different year selection in the slicer it is not holding blue color. Is this kind of formatting not possible in Excel 2010 without using VBA code?

Regards,Eshwar

[Deepak1157]

ADB Consulting helps small and medium-sized businesses with the resources, expertise, and labor required to launch products using printed circuit boards (PCBs). The PCBs we assemble comply with standards adopted by ISO 9001-2000, as well as any other requirements that are relevant to the customer, such as local environmental or other regulations.....

automateandvalidate