Pivot Chart Question

[Spyderturbo007]

I've successfully created a pivot chart that allows me to select an eCommerce store by name and view monthly sales data. It works great when it's a single store, but when I add multiple stores, the chart splits the X axis into individual stores. I'd like it to just add another line to the chart. Not all stores have sales in every month, so I'd just want that to be 0, or even not show a data point.

How can I modify the chart to add a line, as opposed to splitting the X-Axis?

Thank you!

 

[Sergius]

In the summary table, transfer the stores to "columns". Then it will draw as you need.