How Do You Do Combination Charts In Excel 2007?
Excel 2007 provides functions through a tabbed toolbar and a file menu under the Office ribbon. Options organized in this format present the user with grouped functions according to categories. A combination chart consists of one primary chart type, such as a bar chart for one set of data (data series) and a secondary chart type such as a line chart for the second data series. Excel 2007 initially prepares a chart based on two primary data sets; creating a combination chart requires selecting the second data series and specifying it as a secondary axis with a different chart type. Launch Microsoft Excel and open the spreadsheet containing data by selecting “Open” under the Office ribbon, selecting the desired file and clicking the “Open” button. Check that the data is organized in columns, with the first column containing the categories and the second and third columns containing values. Highlight all three columns by selecting the top of the first column and the bottom of the third co
