I am trying to do a stacked bar chart that displays multiple weeks of data in 1 view. Below is a table for the first week of data. There will be similar data for the next few weeks. I one stacked bar column i would like to display Stock Room A (high an d low with 2 colors). The 2nd bar would have the Stock Room B high and low values. How can i group them by week? If stacked bar chart is not the best option to represent this that is fine, i am open to suggestions. I know this is possible but i just cant seem to figure it out. Thanks in advanced!!!
Stock Room A 41% (High) 59% (Low)
Stock Room B 24% (High) 76% (Low)
Bookmarks