Pivot Table/Chart

[Steve J]

Hi is it possible to have 2 separate sets of series in one table/chart.

i have 4 rows - Weeks 1-4
I have 8 columns - Qty 1-4 and Cost 1-4

I would like to display all the data in one table/chart?

Thanks
S

 

[Debra Dalgleish]

If you create a pivot chart, it should show all the data that's in the
pivot table. What problem are you having with the chart?

 

[Alex H]

Well If I set up my table to display all the data, ie sinble column showing
4 rows of quantity and four rows of costs. The figures are correct. But
then if I select the data, and de-select one of the items, press Ok, then
the table refreshes Ok. But then if I try to re-select the same item, its
not in the list, and pressing Select ALl has not effect.

I dont use pivit tables/charts very often so I may be (probably) doing
something wrong.

I have assumed that it is because I have two series of data, since the
problem does notoccur whren i just have one series

Thanks for help

S

 

[Debra Dalgleish]

If you deselect an item in the Data area, it's removed from the pivot
table, and from the Data dropdown list. To see it in the chart again,
you can drag it back from the Pivot Table Field List.

 

[Steve J]

Thanks Debras

I was just wondering why it only happens sometimes.

if I just have the 4 quantity totals, then i can delect and reselect and it
disappaers and reappears without any issue. if I have both quantity and
cost data in the table whichever one I de-select it will disappaer and as
you say, wont come back till you drag it back from field listing

S