Hi Charles,
Thanks for reaching out! It sounds like you want to create a chart that combines multiple subplots into one chart. This is definitely possible in Excel.
Here are the steps you can follow:
- Select the data for both TS A and TS B.
- Click on the "Insert" tab in the Excel ribbon.
- Click on the "Recommended Charts" button.
- In the "All Charts" tab, select the "Combo" chart type.
- In the "Combo" chart type, select the "Clustered Column - Line" chart subtype.
- Click "OK" to create the chart.
- You should now have a chart that shows both TS A and TS B on the same chart.
- To customize the chart further, you can right-click on any element of the chart (e.g. the legend, the axis labels, etc.) and select "Format [element name]" to make changes.
Let me know if you have any questions or if there's anything else I can do to assist you.
Best regards,
[Your Name]