My Oracle Support Banner

OBIEE 11g - Export to Excel Shows Wrong Legend Colors of Cylindrical Bar (Doc ID 2039587.1)

Last updated on NOVEMBER 26, 2019

Applies to:

Business Intelligence Interactive Dashboard - Version and later
Information in this document applies to any platform.


Export of Cylindrical Bar Chart shows different Legend colors. Below are the steps to reproduce the issue.

  1. Created simple analysis with Revenue, Per Name Year, Products. Use filter  on Product column to display only 3 products.  For eg P1, P2, P3 
  2. Create stacked vertical Graph with Revenue on X axis, Per Name Year in Y  axis and Products in Legends. 
  3. Choose Bars in cylindrical format. 
  4. Edit graph properties to use custom colors by using conditional  formatting.Navigate to 
    • Graph Properties -> Style -> Styles and Conditional Formatting -> Conditional Formatting 
  5. Add Conditions in Product to choose some color other then default colors. 
  6. Save the report. 
  7. Export to Excel and verify Legends. Legends are not getting changed. 




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.