Pivot Table Splits Columns for same entry

  • Thread starter Thread starter Tycon22
  • Start date Start date
T

Tycon22

I have a column that splits into two columns when plotted on the pivo
table chart. The legend reads the output correctly (ie. the legen
shows the value of the column is 7, but i have two columns displayed a
5 and 2) I have rearranged the pivot table layout so that my column
read the output correctly, but now i have duplicates in my legend (ie
there is one column of 7 but in two different colors showing the spli
of 5 and 2, and in the legend there are two boxes with the appropriat
colors showing a 7 for each) I was wondering if anyone has encountere
such a peculiar problem with pivot tables? Thanks
 
The Chart Wizard created a stacked column chart. The values for that
item in your pivot table must be 5 and 2, for a subtotal of 7.

To change to clustered columns, select the chart
Choose Chart>Chart Type
Select the Column chart type, and the Clustered column subtype.
Click OK
 
Back
Top