Set colour on box-and-whisker chart with tabbed interface
We are showing a box-and-whisker chart based on a field and a category ... This is for a hospital and we also want to show the benchmark data.
This is no quite possible to show in one chart with YF so we added a section field (called level) so you can switch between the hospital and benchmark tabs to see the box-and-whiskers chart per category. This is working nicely.
In all our chart we have the hospital data shown in blue and benchmark data show in green so we would like to be able to do that also in this chart. I use a referencecode for the color of the level field but when I apply that in the data part of the report it is not transferred to the chart. There is also not a possibility to define it in the chart part of the report.
Also there is no option to manually set the colors. When do not use the sections in the data part but include the level field in the column I am unable to add more then 1 vertical axis field so that is not an option also.
Having 2 box-and-whisker bars per category would also be fine by me.
Maybe an option to add? Let me know if it is clear what I would like to do.