Chart Data Dark Theme
Region Jan Feb Mar Apr May Jun
East $8,625 $6,750 $7,125 $7,125 $7,750 $7,625 This shape represen
North $13,200 $12,400 $9,200 $12,400 $14,000 $13,200 a slicer. Slicers are
Labels: $ Amount
supported in Excel
South $9,950 $6,650 $7,250 $9,200 $8,750 $7,700
2010 or later.
West $2,610 $2,650 $2,610 $2,570 $2,570 $2,800
Total $34,385 $28,450 $26,185 $31,295 $33,070 $31,325 If the shape was
$34,385
modified in an earli
version of Excel, or
$2,610
the workbook was
Labels saved$9,950
in Excel 2003
or earlier, the slicer
$ Amount cannot be used.
Region Jan Feb Mar Apr May Jun
East $8,625 $6,750 $7,125 $7,125 $7,750 $7,625 $13,200
North $13,200 $12,400 $9,200 $12,400 $14,000 $13,200
South $9,950 $6,650 $7,250 $9,200 $8,750 $7,700
West $2,610 $2,650 $2,610 $2,570 $2,570 $2,800 $8,625
Total $34,385 $28,450 $26,185 $31,295 $33,070 $31,325
Jan
% of Total
Region Jan Feb Mar Apr May Jun
East 25.1% 23.7% 27.2% 22.8% 23.4% 24.3%
North 38.4% 43.6% 35.1% 39.6% 42.3% 42.1% Light Theme
South 28.9% 23.4% 27.7% 29.4% 26.5% 24.6%
West 7.6% 9.3% 10.0% 8.2% 7.8% 8.9% This shape represen
Total 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% a slicer. Slicers are
supported in ExcelM
Labels: % Change
2010 or later.
% Change
Region Jan Feb Mar Apr May Jun If the shape was
East -21.7% 5.6% 0.0% 8.8% -1.6% modified in an earli
$34,385
version
$2,610Excel, or
of
North -6.1% -25.8% 34.8% 12.9% -5.7%
the workbook was
South -33.2% 9.0% 26.9% -4.9% -12.0% saved$9,950
in Excel 2003
West 1.5% -1.5% -1.5% 0.0% 8.9% or earlier, the slicer
Total -17.3% -8.0% 19.5% 5.7% -5.3% cannot be used.
Selected Label $13,200
Index: 1 Labels: $ Amount
Region Jan Feb Mar Apr May Jun
East $8,625 $6,750 $7,125 $7,125 $7,750 $7,625 $8,625
North $13,200 $12,400 $9,200 $12,400 $14,000 $13,200
Jan
South $9,950 $6,650 $7,250 $9,200 $8,750 $7,700
West $2,610 $2,650 $2,610 $2,570 $2,570 $2,800
Total $34,385 $28,450 $26,185 $31,295 $33,070 $31,325
Gradient Theme
This shape represen
a slicer. Slicers are
supported in ExcelM
Labels: % Change
2010 or later.
If the shape was
$34,385
modified in an earli
$2,610
version of Excel, or
the workbook was
saved$9,950
in Excel 2003
or earlier, the slicer
cannot be used.
$13,200
$8,625
Jan
Dark Theme
This shape represents
a slicer. Slicers are Sales by Region
Labels: $ Amount
supported in Excel
2010 or later.
If the shape was
$34,385
modified in an earlier $33,070
version of Excel, or if
$2,610 $31,295 $31,325
$2,570
the workbook was $28,450 $2,570 $2,800 West
saved$9,950
in Excel 2003 $2,650 $26,185 South
$2,610 $8,750
or earlier, the slicer $9,200 $7,700 North
cannot be used. $6,650
$7,250 East
$13,200 $14,000 $13,200
$12,400 $12,400
$9,200
$8,625 $6,750 $7,125 $7,125 $7,750 $7,625
Jan Feb Mar Apr May Jun
Light Theme
This shape represents
a slicer. Slicers are Sales by Region
supported in ExcelMoM
Labels: % Change
2010 or later.
If the shape was
modified in an earlier
$34,385
$33,070
version
$2,610Excel, or if
of $31,295 $31,325
the workbook was $28,450 $2,570
$2,570 $2,800 West
saved$9,950
in Excel 2003 $2,650 $26,185 South
or earlier, the slicer $2,610 $8,750
$9,200 $7,700 North
cannot be used. $6,650
$7,250 East
$13,200 $14,000 $13,200
$12,400 $12,400
$9,200
$8,625 $6,750 $7,125 $7,125 $7,750 $7,625
Jan Feb Mar Apr May Jun
Gradient Theme
This shape represents
a slicer. Slicers are
Sales by Region
supported in ExcelMoM
Labels: % Change
2010 or later.
If the shape was
$34,385
modified in an earlier $33,070
$2,610
version of Excel, or if $31,295 $31,325
$2,570
the workbook was $28,450 $2,570 $2,800 West
in Excel 2003 $2,650
saved$9,950 $26,185 South
$2,610 $8,750
or earlier, the slicer $9,200 $7,700 North
cannot be used. $6,650
$7,250 East
$13,200 $14,000 $13,200
$12,400 $12,400
$9,200
$8,625 $6,750 $7,125 $7,125 $7,750 $7,625
Jan Feb Mar Apr May Jun
Name Symbol Index Name Index Symbol
$ Amount $ 1 $ Amount 1 $
% of Total %∑ 2
% Change MoM %↕ 3
(empty)
Author: Jon Acampora
Source: http://www.excelcampus.com/charts/dynamic-chart-data-labels-slicers/
