Excel 2013 - Charts color scheme - gradient option

[mrcruse]

Hi all,

In 2013 charts, bar and line, the default option is a color scheme that doesn't demonstrate a change from lowest to highest (blue, grey, orange, etc.).

I know that I can change colors manually for each data category, but it's extremely time-consuming when I have multiple categories. Is there an easy way to have a color scheme automatically follow a gradient, either from deep red to deep blue, or something similar?

Thanks

 

[mrcruse]

Annnnnd never mind. Figured it out.