From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Modifying a column chart

Modifying a column chart - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Modifying a column chart

Chances are that after you create a chart, you will want to make some changes and customize it to your liking. All the tools you need for that are under the Chart Tools section that appears when you have the chart selected. So I am going to click the chart and now I have the Chart Tools section on the Ribbon bar with three tabs underneath it. If you don't see that Chart Tools section, it's just because you don't have the chart selected. Now you can scroll down to see it a little better. I am just going to move the chart up here so we can see the whole thing. Before we start formatting it, let's say you decide that you want this chart to be on its own sheet. See down here we have our Data sheet, which is where all our data is, and then we have Sheet2 and Sheet3, which are blank. So make sure the chart is selected, click the Design tab here under Chart Tools, and over here on the right, click Move Chart. Now, right now it tells you that it's an object in this Data sheet. Click New…

Contents