Right-click on this chart object and choose 'Select Data.' from the popup menu. In the Charts group, click on the Column button and select the first chart (Clustered Column) under 2-D Column.Ī blank chart object should appear in your spreadsheet. Question: How do I create a chart in Excel that has two Y-axes and one shared X-axis in Microsoft Excel 2007?Īnswer:First, select the Insert tab from the toolbar at the top of the screen. This Excel tutorial explains how to create a chart with two y-axes and one shared x-axis in Excel 2007 (with screenshots and step-by-step instructions). MS Excel 2007: Create a chart with two Y-axes and one shared X-axis