How to do it…

  1. Open the App overview and create a new sheet.
  2. Create a Bar chart on the sheet.
  3. Use Product as the dimension.
  4. Use Sum (Actuals) as the measure. Label it as Actuals.
  5. Under Colors and legend, switch off Auto colors to activate Custom colors.
  6. Along with the Custom colors, a dropdown to define the colors is also activated. This is situated right below the colors switch. Under this dropdown, select By expression.
  7. Add the following expression under the color expression:
=[Product color]
  1. Make sure that The expression is a color code is checked.
  1. The result should be as follows:

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset