How do we control the color of the chart. I have tried the Member based formatting in charts.
I have formatted the members of the table and in the chart formatting i have choosen the color dropdown as "same as table". Now i see the color of the chart is same as in table. Every thing works perfect until here. When i save the view, close and then reopen the view all the formatting is gone. I can still see the table color but i do not see that in the chart.
Did anyone had the same problem.
Thank you.
Executive Viewer Charts
-
- MVP
- Posts: 3703
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Executive Viewer Charts
Can't say I've ever had a need to stray off the theme colours but I guess if you have a corporate dictated colour scheme for charts then you might need to.
Sounds like a bug as any view preference should be saved and still be there when a view is reopened. Have you tried a dynaselect to set the chart colours to the grid colours? That might work.
also try http://www.evusers.org/index.php it doesn't get as much activity as this forum but it is EV specific
Sounds like a bug as any view preference should be saved and still be there when a view is reopened. Have you tried a dynaselect to set the chart colours to the grid colours? That might work.
also try http://www.evusers.org/index.php it doesn't get as much activity as this forum but it is EV specific