In Excel you can format a cell's fill effect to be a gradient. Can ODS EXCEL create the same?
Hi:
My guess is that it would depend on what procedure you were using to create your output within the ODS EXCEL statements. For example, you can use gradient fills in SG procedure graphics so my guess is that you could send that SG procedure output to ODS EXCEL and that would work. However, I am having a hard time understanding how you would use a gradient fill in tabular output, such as with PROC REPORT, TABULATE or PRINT.
Do you have any concrete example of how your gradient fill looks in the Excel worksheet after you apply the gradient?
Cynthia
I am creating total counts from different combinations of item counts. An item can be in 1 or 2 different total sums, so I am trying to show which totals they contribute to via a color-coding scheme.
In this simple sample I am trying to use header colors to show how the Count_a,b,c,d,e components are used to compose the totals Count_X,Y,Z.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.