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.
#CHANGE THE DISPLAY OF THE VERTICAL AXIS IN EXCEL FOR MAC HOW TO#
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 kommentar(er)
