[go: up one dir, main page]
Scribd
Upload
71 views3 pages

Dashboard Data File

This document discusses slicers in Excel and how they can be used to filter data. It explains that slicers are supported in Excel 2010 or later, but if a shape was modified in an earlier version of Excel or the workbook was saved in Excel 2003 or earlier, the slicer may not function properly. Two charts are also included that show example data filtered by product name and category for the year 2013.

Uploaded by

SIDI MOHAMMED BENDELLA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
71 views3 pages

Dashboard Data File

This document discusses slicers in Excel and how they can be used to filter data. It explains that slicers are supported in Excel 2010 or later, but if a shape was modified in an earlier version of Excel or the workbook was saved in Excel 2003 or earlier, the slicer may not function properly. Two charts are also included that show example data filtered by product name and category for the year 2013.

Uploaded by

SIDI MOHAMMED BENDELLA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

This shape represents a slicer.

This shape re
line chart trend line for 2013 by product Slicers are supported in Excel Slicers are su
2010 or later. 2010 or later.
6000
4000 If the shape was modified in If the shape w
2000 an earlier version of Excel, or an earlier vers
Product Name $1 Lottery if the workbook was saved in if the workbo
0 Ticket
Excel 2003 o
sales in $

s s s s s s $10 Lottery Ticket


Excel 2003 or earlier, the slicer
le le le le le le cannot be used. cannot be use
Sa Sa Sa Sa Sa Sa
13 13 13 13 13 13
y 20 20 y 20 y 20 r 20 r 20
h
ar rc a Jul be be
a nu Ma of M of em em column char
J f t v
of m o um Sum Sep f No
m u S of o 60000
Su S m um
Su S
50000
line chart trend for 2013 sales by product
40000
category
30000 30000
20000
10000 20000
0 Product Category Beverage
sales in $

10000

0
Product Name
This shape represents a slicer. This shape represents a slicer. Slicers are supported in Excel 2010 or later.
Slicers are supported in Excel
2010 or later. If the shape was modified in an earlier version of Excel, or if the workbook was saved in Exc
2003 or earlier, the slicer cannot be used.
If the shape was modified in
an earlier version of Excel, or
if the workbook was saved in
Excel 2003 or earlier, the slicer
cannot be used.

column chart that shows total sales for each year by product

Data
Column C
Column D

uct Name $1 Lottery Ticket $10 Lottery Ticket


later.

kbook was saved in Excel

Total 2013 sales


Drug
6%

Beverage
94%

You might also like