Yes!!! oh man struggling to figure it outHi dblue824,
Welcome to the forum.
Have a look of attached file. Is this what you want?
Regards,
Im sorry I didn't solve it, can you help me with how you created the chart? its exactly how I want it to look, appreciate it@dblue824
Glad you solve it.
@3G
Structuring the data in the layout as in file. Select All data and create Column chart. Now go to select data dialogue box. In series you will see 3 series. Remove 2 series except sales and than in X- Axis select column A:B. Thats it!
You can also achieve this by creating pivot table.
Regards!