![]() To do this, highlight cells A2 to A7 then type a comma, then highlight cells C2 to C7, then type another comma, and the highlight cells E2 to E7. ![]() One more complication to this example is that our data is not all in adjacent cells, so we need to select columns A, C, and E separated by commas. In this example, we want column A to represent our X-axis and column C to represent our primary Y-axis (left side) and column E to represent our secondary Y-axis (right side). When the Select Data Source window appears, we need to enter the data that we want to graph. 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
0 Comments
Leave a Reply. |