Excel 2007 Tutorial 4.1. Pie, Column & Line Charts

In this video:
Pie Charts
Data Labels & Leader Lines
Chart Titles & Styles
Column Charts
Clustered vs. Stacked Charts
Line Charts
Select Data
Format Axis
Insert Shapes

The Excel file used in this video can be found at:
http://www.djdates.com/charts.xls

The data in this video was sourced from Netcraft.com and Wikipedia.org.

Category:

Education

Tags:

• Microsoft
• Excel
• 2007
• Office
• spreadsheet
• pie
• column
• line
• chart
• Data
• Label
• Leader
• Lines
• Titles
• Styles
• Clustered
• Stacked
• Select
• Format
• Axis
• Shapes
• 2010

[kevtyan]

hi, how do you make a break in the y-axis for excel 2007??

please help

[djdates]

@kevtyan It looks like the only way to do that is through a bit of a hack. Google (excel 2007 broken axis) and you will find people discussing techniques.

[DidilovesJoey8]

Does any 1 knows how to edit the values of the axes??? Pls help

[djdates]

@DidilovesJoey8 You can right click on your chart and click on select data to change which cells are used to populate the chart. This is done in the video at 5:46 .

[Talisha2000]

THANKS!!! This video helped finish my assignment on reading.....That assignment gave me a headache though.

[shahbaz3d]

Thank you Sir,

[djdates]

@OfficialTheoDaniels Fill Handle is the little tiny square at the lower right edge of a selected cell. The Fill Handle is used to quickly copy data or formulas, or generate a series. If you jump to 4:42 in this video and click on the red box, it will take you to the section of Tutorial 1.1 that describes the Fill Handle.

[iiV1P4z]

great tutorial man! very helpfull

[abdulmenaam]

thanx alot i got it , i understand very well , for a long time im looking for it , im so happy to get it , thanx once again , please do more

[DemiLovatoGirl23]

my picture doesn't show up when i do highlight everything and try to put it into columns what do i do