G
Guest
Under chart options, there's an option to do a stacked bar chart. Is there a
way to do a stacked bar chart that does the following:
I want to show 3 store locations and then have two side-by-side stacked bar
charts above each of the three location - all in one chart. The first
stacked bar would show the number of widgets bought each month of the quarter
(I need to visually represent the number bought for Jan, Feb, and March).
Then right next to it would show the number of widgets sold during the
quarter (again visually representing the number for Jan, Feb, March).
Therefore, when you see the report you'd see a side by side comparison of how
many widgets were bought and sold for each of the three locations. You'd
also be able to visually see the different amounts for each month. Is this
possible?
way to do a stacked bar chart that does the following:
I want to show 3 store locations and then have two side-by-side stacked bar
charts above each of the three location - all in one chart. The first
stacked bar would show the number of widgets bought each month of the quarter
(I need to visually represent the number bought for Jan, Feb, and March).
Then right next to it would show the number of widgets sold during the
quarter (again visually representing the number for Jan, Feb, March).
Therefore, when you see the report you'd see a side by side comparison of how
many widgets were bought and sold for each of the three locations. You'd
also be able to visually see the different amounts for each month. Is this
possible?