Hi Ted & Anna,   I contacted Tech support & Ted you are correct.   If the Custom chart shows a 'greyed out' option, it is not available for that chart type.   The charts that support the Colour option are; - Scatter Plot - Bubble Plot - Tree Map - Geo Bubble Map - Geo Region Map - Word Cloud   I also found out how to Change Colours for Chart lines, Bars etc the right way.   Firstly, when you have your Chart & Roles selected, the default colour, Blue, will be shown as the first colour for the chart.   In order to change this, Select your chart object and go to the 'Styles' Tab >> 'Data Colors' area & note the 'Fill' Colours have the Blue colour in the Top Left position.   If you want to change this colour, firstly select the Blue colour in the Top Left of the 'Fill' area boxes, this will open the Custom Colours chart where you can select another colour.   Select another colour & it will replace the Blue on the chart.   Note the new colour moves to the Top left of the 'Fill' colours box.   Also, note that the colours in the 'Fill' box aren't just random colours, the Top Row reflects the colours already in the Chart.   So you can select that colour, go to the custom colours, choose another colour & it will update.   This info is not documented in the User Manual but should be as it was driving me crazy trying to change colours.   Btw, tech Support had to try the U.S. to get this info so can someone at SAS please get this detail added to the User manual??   Thanks & I hope this helps other users.     With multiple colours, you can select a new colour by selecting the colours           ... View more

Hi, I found that it's not straightforward to add selected colours to a Stacked Column chart. I found it was really a trial & error process to get the colours I wanted. Particularly for a stacked Column, I found I was changing some random settings, then changing the Data Color under the Styles tab. Sometimes it worked but usually din't so I spent quite some time getting the colours I needed.  ... View more

I found the answer.   My project had some daily data & I added a blank date field as a calculated column using ''d as the format.   This is where I wanted to add the selected date from the 'Datepicker' prompt.   First step is to create the Prompt, then 'Register' the Prompt by right clicking on the Query Builder & selecting Properties >> Prompts & select the Prompt you want.   Next I added a Case Statement that just said If the date field of the table was blank, then insert the Prompt date.   CASE WHEN t1.DATE_ID IS NULL THEN "&Report_Date"d END NOTE the double quotes around the Prompt name.   Now when the Project is run, a datepicker pops up, the User selects a date & it appears in the first row of the table.     ... View more