Quantcast
Sign Up For Our Newsletter
Email:

I4C

Using the Chart Tools tab in Excel 2007

advertisement

Using Excel in a Classroom

Using the Chart Tools Tab in Excel 2007


This tab only appears when a chart is selected. As soon as the chart is deselected, this tab disappears.



Tip: If you are unsure what the function of a feature is, let your cursor hover over the button (in Excel) to see a pop-up box explaining the feature.
If you want to collapse the ribbon so that none of the buttons are displayed, double-click the name of the tab.



Type
Change Chart Type - Change to a different type of chart.
Save as Template - Save the formatting and layout of this chart as a template you can apply to future charts.

Data
Switch Row/Column - Swap the data over the axis. Data being charted on the X axis will move to the Y axis and vice versa.
Select Data - Change the data range included in the chart.

Chart Layouts
Chart Layouts - To see all layouts click on the down arrow at the bottom right of this section; the button is outlined in red in the image above. There are eleven layouts available and a small thumbnail of each is given showing where titles, legends and other information will be located.

Chart Styles
Protect Sheet - To see all styles click on the down arrow at the bottom right of this section; the button is outlined in red in the image above. There are six distinct styles and each is available in one of eight color schemes.

Location
Location - Move this chart to a new sheet or to imbed the chart as a smaller object in any other sheet of the workbook.

Quiz
1.

This Excel tab is simple and almost self explanatory. Thus it does not require a quiz.
   

x

Internet4classrooms is a collaborative effort by Susan Brooks and Bill Byles.
 

  

advertisement

advertisement

Use of this Web site constitutes acceptance of our Terms of Service and Privacy Policy

281313997 US 1 desktop not tablet not iPad device-width