Clustered Bar Chart split bar into 2 categories (Clustered and stacked bar chart?)

I have a clustered bar chart with values from 3 different queries. Is it possible to have the values split by another category within each bar? In the graph below, each color is a different is a different store, but i would like that bar to be split into a N and R which each value has that label in a different column within the query.... essentially a clustered and stacked bar chart