Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Improve the "Vary colors by point" option

The current version of the "Vary colors by point" option is of limited use and indeed contrary to accepted data visualization best practices, since it randomly assigns different colors to bars. The user should have the option to apply conditional color encoding by assigning colors based on some data, creating a color scale (ramp or categorical). As a practical example, a bar chart displaying population by country could use population density to generate a color ramp for bars or variation by category (continents).

29 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jorge Camoes shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base