1.5 做法分析 自制图例

GREEN ACRES

Since 2000,the value of american

farmland has risen much faster

than the stock market

INDEX: JAN. 1,'00=100

数据来源：ExcelPro的图表博客

杂志图表案例Excel中的做法

自制图例

■AVERAGE PRICE PER ACRE OF AGEICULTURAL REAL ESTATE ■STANDARD &

PROR'S 500-STOCK ■AVERAGE PRICE PER ACRE OF AGEICULTURAL REAL ESTATE

■STANDARD &

PROR'S 500-STOCK

50

100

150

200

'00'01'02'03'04'05'06■AVERAGE PRICE PER ACRE OF

AGEICULTURAL REAL ESTATE

■STANDARD &

PROR'S 500-STOCK

●AVERAGE PRICE PER ACRE OF

AGEICULTURAL REAL ESTATE

●STANDARD &

PROR'S 500-STOCK

■AVERAGE PRICE PER ACRE OF AGEICULTURAL REAL ESTATE ■STANDARD &

PROR'S 500-STOCK

STANDARD &使用原图例'00100

'0190

'0270

'0385

'0495

'0599

'06105

AVERAGE PRICE PER ACRE OF AGEICULTURAL REAL ESTATE 100

105

110

115

125

150

175