EXCEL のグラフスタイル

EXCEL のグラフを VBA で作成する際には AddChart2 メソッドを使う.その時,最初の定数で Style を指定する.これはグラフスタイル (ChartStyle) であるが,実はこのグラフスタイルには公式文書が存在しない.

今回は備忘録としてグラフスタイルの記事を公開する.

グラフタイプ

ChartType タイプ
xlColumnClustered 集合縦棒
xlColumnStacked 積み上げ縦棒
xlColumnStacked100 100% 積み上げ縦棒
xl3DColumnClustered 3-D 集合縦棒
xl3DColumnStacked 3-D 積み上げ縦棒
xl3DColumnStacked100 3-D 100% 積み上げ縦棒
xl3DColumn 3-D 縦棒
xlLine 折れ線
xlLineStacked 積み上げ折れ線
xlLineStacked100 100% 積み上げ折れ線
xlLineMarkers マーカー付き折れ線
xlLineMarkersStacked マーカー付き積み上げ折れ線
xlLineMarkersStacked100 マーカー付き 100% 積み上げ折れ線
xl3DLine 3-D 折れ線
xlPie
xl3DPie 3-D 円
xlPieOfPie 補助円グラフ付き円
xlBarOfPie 補助縦棒付き円
xlDoughnut ドーナツ
xlBarClustered 集合横棒
xlBarStacked 積み上げ横棒
xlBarStacked100 100% 積み上げ横棒
xl3DBarClustered 3-D 集合横棒
xl3DBarStacked 3-D 積み上げ横棒
xl3DBarStacked100 3-D 100% 積み上げ横棒
xlArea
xlAreaStacked 積み上げ面
xlAreaStacked100 100% 積み上げ面
xl3DArea 3-D 面
xl3DAreaStacked 3-D 積み上げ面
xl3DAreaStacked100 3-D 100% 積み上げ面
xlXYScatter 散布図
xlXYScatterSmooth 散布図(平滑線とマーカー)
xlXYScatterSmoothNoMarkers 散布図(平滑線)
xlXYScatterLines 散布図(直線とマーカー)
xlXYScatterLinesNoMarkers 散布図(直線)
xlBubble バブル
xlBubble3DEffect 3-D 効果付きバブル
xlRegionMap 塗り分けマップ
xlStockHLC 株価チャート
xlSurface 3-D 等高線
xlSurfaceWireframe ワイヤーフレーム 3-D 等高線
xlSurfaceTopView 等高線
xlSurfaceTopViewWireframe ワイヤーフレーム等高線
xlRadar レーダー
xlRadarMarkers マーカー付きレーダー
xlRadarFilled 塗りつぶしレーダー
xlTreemap ツリーマップ
xlSunburst サンバースト
xlHistogram ヒストグラム
xlPareto パレート図
xlBoxwhisker 箱ひげ図
xlWaterfall ウォーターフォール
xlFunnel じょうご

グラフスタイル

グラフスタイルはマクロの記録で取得した.下表をピボットテーブルにすると,グラフタイプごとにグラフスタイルの番号がクラスターとして集族しているのが分かる.紙面の都合で図は割愛する.各自で試みてほしい.

ChartType ChartStyle
xlColumnClustered 201
xlColumnClustered 202
xlColumnClustered 203
xlColumnClustered 204
xlColumnClustered 205
xlColumnClustered 206
xlColumnClustered 207
xlColumnClustered 208
xlColumnClustered 209
xlColumnClustered 210
xlColumnClustered 211
xlColumnClustered 212
xlColumnClustered 213
xlColumnClustered 214
xlColumnClustered 215
xlColumnClustered 340
xlColumnStacked 297
xlColumnStacked 298
xlColumnStacked 299
xlColumnStacked 300
xlColumnStacked 301
xlColumnStacked 302
xlColumnStacked 303
xlColumnStacked 304
xlColumnStacked 305
xlColumnStacked 306
xlColumnStacked 348
xlColumnStacked100 297
xlColumnStacked100 298
xlColumnStacked100 299
xlColumnStacked100 300
xlColumnStacked100 301
xlColumnStacked100 302
xlColumnStacked100 303
xlColumnStacked100 304
xlColumnStacked100 305
xlColumnStacked100 306
xlColumnStacked100 348
xl3DColumnClustered 286
xl3DColumnClustered 287
xl3DColumnClustered 288
xl3DColumnClustered 289
xl3DColumnClustered 290
xl3DColumnClustered 291
xl3DColumnClustered 292
xl3DColumnClustered 293
xl3DColumnClustered 294
xl3DColumnClustered 295
xl3DColumnClustered 296
xl3DColumnClustered 347
xl3DColumnStacked 286
xl3DColumnStacked 299
xl3DColumnStacked 310
xl3DColumnStacked 289
xl3DColumnStacked 290
xl3DColumnStacked 294
xl3DColumnStacked 296
xl3DColumnStacked 347
xl3DColumnStacked100 286
xl3DColumnStacked100 299
xl3DColumnStacked100 310
xl3DColumnStacked100 289
xl3DColumnStacked100 290
xl3DColumnStacked100 294
xl3DColumnStacked100 296
xl3DColumnStacked100 347
xl3DColumn 286
xl3DColumn 287
xl3DColumn 288
xl3DColumn 289
xl3DColumn 290
xl3DColumn 291
xl3DColumn 292
xl3DColumn 293
xl3DColumn 294
xl3DColumn 295
xl3DColumn 296
xl3DColumn 347
xlLine 227
xlLine 228
xlLine 229
xlLine 230
xlLine 231
xlLine 232
xlLine 233
xlLine 234
xlLine 235
xlLine 236
xlLine 237
xlLine 238
xlLine 239
xlLine 332
xlLine 342
xlLineStacked 227
xlLineStacked 228
xlLineStacked 229
xlLineStacked 230
xlLineStacked 231
xlLineStacked 232
xlLineStacked 233
xlLineStacked 234
xlLineStacked 235
xlLineStacked 236
xlLineStacked 237
xlLineStacked 238
xlLineStacked 239
xlLineStacked 332
xlLineStacked 342
xlLineStacked100 227
xlLineStacked100 228
xlLineStacked100 229
xlLineStacked100 230
xlLineStacked100 231
xlLineStacked100 232
xlLineStacked100 233
xlLineStacked100 234
xlLineStacked100 235
xlLineStacked100 236
xlLineStacked100 237
xlLineStacked100 238
xlLineStacked100 239
xlLineStacked100 332
xlLineStacked100 342
xlLineMarkers 235
xlLineMarkers 236
xlLineMarkers 237
xlLineMarkers 238
xlLineMarkers 239
xlLineMarkers 332
xlLineMarkers 342
xlLineMarkers 227
xlLineMarkers 228
xlLineMarkers 229
xlLineMarkers 230
xlLineMarkers 231
xlLineMarkers 232
xlLineMarkers 233
xlLineMarkers 234
xlLineMarkersStacked 235
xlLineMarkersStacked 236
xlLineMarkersStacked 237
xlLineMarkersStacked 238
xlLineMarkersStacked 239
xlLineMarkersStacked 332
xlLineMarkersStacked 342
xlLineMarkersStacked 227
xlLineMarkersStacked 228
xlLineMarkersStacked 229
xlLineMarkersStacked 230
xlLineMarkersStacked 231
xlLineMarkersStacked 232
xlLineMarkersStacked 233
xlLineMarkersStacked 234
xlLineMarkersStacked100 227
xlLineMarkersStacked100 228
xlLineMarkersStacked100 229
xlLineMarkersStacked100 230
xlLineMarkersStacked100 231
xlLineMarkersStacked100 232
xlLineMarkersStacked100 233
xlLineMarkersStacked100 234
xlLineMarkersStacked100 235
xlLineMarkersStacked100 236
xlLineMarkersStacked100 237
xlLineMarkersStacked100 238
xlLineMarkersStacked100 239
xlLineMarkersStacked100 332
xlLineMarkersStacked100 342
xl3DLine 307
xl3DLine 311
xl3DLine 308
xl3DLine 309
xlPie 251
xlPie 252
xlPie 253
xlPie 254
xlPie 255
xlPie 256
xlPie 257
xlPie 258
xlPie 259
xlPie 260
xlPie 261
xlPie 344
xl3DPie 262
xl3DPie 263
xl3DPie 264
xl3DPie 265
xl3DPie 266
xl3DPie 267
xl3DPie 268
xl3DPie 259
xl3DPie 261
xl3DPie 345
xlPieOfPie 333
xlPieOfPie 252
xlPieOfPie 334
xlPieOfPie 335
xlPieOfPie 336
xlPieOfPie 337
xlPieOfPie 338
xlPieOfPie 258
xlPieOfPie 259
xlPieOfPie 260
xlPieOfPie 261
xlPieOfPie 344
xlBarOfPie 333
xlBarOfPie 252
xlBarOfPie 334
xlBarOfPie 335
xlBarOfPie 336
xlBarOfPie 337
xlBarOfPie 338
xlBarOfPie 258
xlBarOfPie 259
xlBarOfPie 260
xlBarOfPie 261
xlBarOfPie 344
xlDoughnut 251
xlDoughnut 252
xlDoughnut 253
xlDoughnut 254
xlDoughnut 255
xlDoughnut 256
xlDoughnut 257
xlDoughnut 258
xlDoughnut 260
xlDoughnut 261
xlBarClustered 216
xlBarClustered 217
xlBarClustered 218
xlBarClustered 219
xlBarClustered 220
xlBarClustered 221
xlBarClustered 222
xlBarClustered 223
xlBarClustered 224
xlBarClustered 225
xlBarClustered 339
xlBarClustered 226
xlBarClustered 341
xlBarStacked 297
xlBarStacked 298
xlBarStacked 299
xlBarStacked 300
xlBarStacked 301
xlBarStacked 302
xlBarStacked 303
xlBarStacked 304
xlBarStacked 305
xlBarStacked 306
xlBarStacked 348
xlBarStacked100 297
xlBarStacked100 298
xlBarStacked100 299
xlBarStacked100 300
xlBarStacked100 301
xlBarStacked100 302
xlBarStacked100 303
xlBarStacked100 304
xlBarStacked100 305
xlBarStacked100 306
xlBarStacked100 348
xl3DBarClustered 286
xl3DBarClustered 287
xl3DBarClustered 288
xl3DBarClustered 289
xl3DBarClustered 290
xl3DBarClustered 291
xl3DBarClustered 292
xl3DBarClustered 349
xl3DBarClustered 294
xl3DBarClustered 295
xl3DBarClustered 296
xl3DBarClustered 347
xl3DBarStacked 286
xl3DBarStacked 299
xl3DBarStacked 310
xl3DBarStacked 289
xl3DBarStacked 290
xl3DBarStacked 294
xl3DBarStacked 296
xl3DBarStacked 347
xl3DBarStacked100 286
xl3DBarStacked100 299
xl3DBarStacked100 310
xl3DBarStacked100 289
xl3DBarStacked100 290
xl3DBarStacked100 294
xl3DBarStacked100 296
xl3DBarStacked100 347
xlArea 276
xlArea 277
xlArea 278
xlArea 279
xlArea 280
xlArea 281
xlArea 282
xlArea 283
xlArea 284
xlArea 285
xlArea 346
xlAreaStacked 276
xlAreaStacked 277
xlAreaStacked 278
xlAreaStacked 279
xlAreaStacked 280
xlAreaStacked 281
xlAreaStacked 282
xlAreaStacked 283
xlAreaStacked 284
xlAreaStacked 285
xlAreaStacked 346
xlAreaStacked100 276
xlAreaStacked100 277
xlAreaStacked100 278
xlAreaStacked100 279
xlAreaStacked100 280
xlAreaStacked100 281
xlAreaStacked100 282
xlAreaStacked100 283
xlAreaStacked100 284
xlAreaStacked100 285
xlAreaStacked100 346
xl3DArea 276
xl3DArea 312
xl3DArea 313
xl3DArea 314
xl3DArea 280
xl3DArea 281
xl3DArea 282
xl3DArea 315
xl3DArea 316
xl3DArea 350
xl3DAreaStacked 276
xl3DAreaStacked 312
xl3DAreaStacked 313
xl3DAreaStacked 314
xl3DAreaStacked 280
xl3DAreaStacked 281
xl3DAreaStacked 282
xl3DAreaStacked 315
xl3DAreaStacked 316
xl3DAreaStacked 350
xl3DAreaStacked100 276
xl3DAreaStacked100 312
xl3DAreaStacked100 313
xl3DAreaStacked100 314
xl3DAreaStacked100 280
xl3DAreaStacked100 281
xl3DAreaStacked100 282
xl3DAreaStacked100 315
xl3DAreaStacked100 316
xl3DAreaStacked100 350
xlXYScatter 240
xlXYScatter 241
xlXYScatter 242
xlXYScatter 243
xlXYScatter 244
xlXYScatter 245
xlXYScatter 246
xlXYScatter 247
xlXYScatter 248
xlXYScatter 249
xlXYScatter 250
xlXYScatter 343
xlXYScatterSmooth 240
xlXYScatterSmooth 241
xlXYScatterSmooth 242
xlXYScatterSmooth 243
xlXYScatterSmooth 244
xlXYScatterSmooth 245
xlXYScatterSmooth 246
xlXYScatterSmooth 247
xlXYScatterSmooth 248
xlXYScatterSmooth 249
xlXYScatterSmooth 250
xlXYScatterSmooth 343
xlXYScatterSmoothNoMarkers 240
xlXYScatterSmoothNoMarkers 241
xlXYScatterSmoothNoMarkers 242
xlXYScatterSmoothNoMarkers 243
xlXYScatterSmoothNoMarkers 244
xlXYScatterSmoothNoMarkers 245
xlXYScatterSmoothNoMarkers 246
xlXYScatterSmoothNoMarkers 247
xlXYScatterSmoothNoMarkers 248
xlXYScatterSmoothNoMarkers 249
xlXYScatterSmoothNoMarkers 250
xlXYScatterSmoothNoMarkers 343
xlXYScatterLines 240
xlXYScatterLines 241
xlXYScatterLines 242
xlXYScatterLines 243
xlXYScatterLines 244
xlXYScatterLines 245
xlXYScatterLines 246
xlXYScatterLines 247
xlXYScatterLines 248
xlXYScatterLines 249
xlXYScatterLines 250
xlXYScatterLines 343
xlXYScatterLinesNoMarkers 240
xlXYScatterLinesNoMarkers 241
xlXYScatterLinesNoMarkers 242
xlXYScatterLinesNoMarkers 243
xlXYScatterLinesNoMarkers 244
xlXYScatterLinesNoMarkers 245
xlXYScatterLinesNoMarkers 246
xlXYScatterLinesNoMarkers 247
xlXYScatterLinesNoMarkers 248
xlXYScatterLinesNoMarkers 249
xlXYScatterLinesNoMarkers 250
xlXYScatterLinesNoMarkers 343
xlBubble 269
xlBubble 270
xlBubble 271
xlBubble 272
xlBubble 246
xlBubble 242
xlBubble 273
xlBubble 248
xlBubble 274
xlBubble 343
xlBubble3DEffect 269
xlBubble3DEffect 270
xlBubble3DEffect 272
xlBubble3DEffect 246
xlBubble3DEffect 242
xlBubble3DEffect 273
xlBubble3DEffect 248
xlBubble3DEffect 343
xlRegionMap 495
xlRegionMap 496
xlStockHLC 322
xlStockHLC 323
xlStockHLC 324
xlStockHLC 327
xlStockHLC 330
xlStockHLC 331
xlSurface 307
xlSurface 311
xlSurface 308
xlSurface 309
xlSurfaceWireframe 307
xlSurfaceWireframe 311
xlSurfaceWireframe 308
xlSurfaceWireframe 309
xlSurfaceTopView 307
xlSurfaceTopView 311
xlSurfaceTopView 308
xlSurfaceTopView 309
xlSurfaceTopViewWireframe 307
xlSurfaceTopViewWireframe 311
xlSurfaceTopViewWireframe 308
xlSurfaceTopViewWireframe 309
xlRadar 317
xlRadar 318
xlRadar 319
xlRadar 320
xlRadarMarkers 317
xlRadarMarkers 318
xlRadarMarkers 319
xlRadarMarkers 320
xlRadarFilled 317
xlRadarFilled 318
xlRadarFilled 319
xlRadarFilled 320
xlTreemap 411
xlTreemap 413
xlTreemap 414
xlTreemap 415
xlTreemap 416
xlTreemap 417
xlTreemap 418
xlSunburst 382
xlSunburst 383
xlSunburst 384
xlSunburst 385
xlSunburst 386
xlSunburst 387
xlSunburst 388
xlHistogram 367
xlHistogram 368
xlHistogram 369
xlHistogram 371
xlPareto 367
xlPareto 368
xlPareto 370
xlPareto 371
xlBoxwhisker 407
xlBoxwhisker 408
xlBoxwhisker 409
xlBoxwhisker 373
xlBoxwhisker 374
xlWaterfall 396
xlWaterfall 397
xlWaterfall 398
xlWaterfall 399
xlWaterfall 400
xlWaterfall 372
xlWaterfall 389
xlFunnel 423
xlFunnel 424
xlFunnel 425
xlFunnel 426
xlFunnel 427
xlFunnel 428
xlFunnel 429
xlFunnel 430
xlColumnClustered 322
xlColumnClustered 323
xlColumnClustered 221
xlColumnClustered 225

コメントを残す

メールアドレスが公開されることはありません。 * が付いている欄は必須項目です

このサイトはスパムを低減するために Akismet を使っています。コメントデータの処理方法の詳細はこちらをご覧ください