The SAS Output Delivery System and reporting techniques

Shades of color using Excelxp

Reply
Regular Contributor
Posts: 155

Shades of color using Excelxp

Hi,

 

I am using excel xp and proc report to generate my report.If i want to use different shades of color how to use it

For ex: If i want to use shade of blue instead of dark or light as we have options in excel how can i tell which shade of blue to use

 

SAS Super FREQ
Posts: 8,721

Re: Shades of color using Excelxp

Hi:

  Typically, you use a STYLE(area)= override in the PROC REPORT syntax or else you change the style template. Here's an example of the using the override in the PROC REPORT syntax.

cynthia

specify_color_xp.png

Grand Advisor
Posts: 17,464

Re: Shades of color using Excelxp

If you feel like digging, Vince Del Gobbo's index is a great place to find the answers.

Find the topic in the first column and then it tells you what paper and page has the answer. There's usually code examples.

 

http://www.sas.com/events/cm/867226/ExcelXPPaperIndex.pdf

Grand Advisor
Posts: 10,251

Re: Shades of color using Excelxp

Be prepared to see fewer colors than expected if you use close shades. Excel has a habit of taking colors that are similar and only displaying one close its default list.

Ask a Question
Discussion stats
  • 3 replies
  • 241 views
  • 0 likes
  • 4 in conversation