Colored Stacked Bar Chart with Grey Area Overlay Displaying 75%-125% of the Average Count
Looking to create a bar chart that is using colors based on a dimension for the vertical lines, while also placing an average amount of the count as a grey horizontal line. The average amount would then need to expand and include 75%-125% of its value over time, please see image below for details on what I'm looking to create, thank you!
Insert the Grey Portion:
Current look of the Bar Chart:
2 replies
-
Hi Travis,
I did it like that: I have a simple column chart (measure: AKTIVIERUNG_NEUVERTRAEGE, color: BLUE) and additionally three formulas, delivering three measures, i.e. the average over time (time is JAHR_MONAT_ID here), this average multiplied by 1.25 and this average multiplied by 0.75.
I put all measures in the Values drop zone. In order to not automatically get a trellis you have to drag the measures to the drop zone, place them above the three points and then select the Primary Axis for all measures and an appropriate visualization, accordingly.
I choose "Column Chart" for AKTIVIERUNG_NEUVERTRAEGE, "Line Chart" for the average, and for the 75% and the 125% average I choose an "Area Chart". After arranging the order of the measures in the Values drop zone and selecting meaningful colors for the measures it looks like this:
The "magic" comes from selecting the chart's background color as the 75% average Area Chart color! So, actually you do not see the 75% area chart at all which leads to a strip (instead of an full area) for the 125% average area chart. The normal/100% average is drawn as a simple line in front of the columns.
Hope this helps,
Micha-
This looks perfect, thank you very much! I will give this a shot and let you know how it goes, really appreciate the assistance!!
-