Pivot Table/Chart
 

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

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?

Steve J wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" wrote in message
...
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?

Steve J wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

Alex H wrote:
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" wrote in message
...

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?

Steve J wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote in message
...
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.

Alex H wrote:
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" wrote in message
...

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?

Steve J wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html