Soluții

Two-dimensional Pivot Table

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.

[mai mult...]

Create a graph in Excel

 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.
[mai mult...]