Soluții

Two-dimensional Pivot Table

• Data 01/11/2023
• Autor marius baciu
• -6
• 234

If you drag a field to the Rows area and Columns area, you can create a two-dimensional pivot table. First, insert a pivot table. Next, to get the total amount exported to each country, of each product, drag the following fields to the different areas.

Pivot table in excel

• Data 01/11/2023
• Autor marius baciu
• 0
• 293

Pivot tables are one of Excel‘s most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.

Create a graph in Excel

• Data 01/11/2023
• Autor marius baciu
• 14
• 330

Consider the type of graph you want to make. There are three basic types of graph that you can create in Excel, each of which works best for certain types of data:

• Bar – Displays one or more sets of data using vertical bars. Best for listing differences in data over time or comparing two similar sets of data.
• Line – Displays one or more sets of data using horizontal lines. Best for showing growth or decline in data over time.
• Pie – Displays one set of data as fractions of a whole. Best for showing a visual distribution of data.