True/False
Salena has created a chart to show the sale of products of her firm in different cities during different years.The chart has only one series with all the columns of the same color.The Year and Location fields are both in the Rows area.Now,she wants to create columns with different colors,for which she will have to move one of the fields into the Column area in the PivotTable Field List.To do so,Salena can follow the following series of clicks/ entries/ selections to do so: Pivot Chart > Pivot Chart Field window > Drag the Year field from the Axis box (Categories)to the Legend (Series)box.This will create a series for each city,and show the city's columns in a different color.
Correct Answer:

Verified
Correct Answer:
Verified
Q29: Which of these functions will you use
Q30: A small grocery owner creates a table
Q31: To use more than one filters per
Q32: When we add fields to the Column
Q33: To insert a scroll bar (form control)into
Q34: To clear all the data from a
Q36: To see the data source for the
Q37: A shopkeeper creates an Excel sheet to
Q38: To insert an option button into a
Q39: Xan wants to change the number format