|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
05-04-2005, 01:06 PM
|
|||
|
|||
|
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 
|
|
#2
05-05-2005, 12:06 AM
|
|||
|
|||
|
Re: Pivot Table/Chart
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
|
|
#3
05-05-2005, 07:06 AM
|
|||
|
|||
|
Re: Pivot Table/Chart
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" <dsd@contexturesXSPAM.com> wrote in message news:427981B2.1080007@contexturesXSPAM.com... > 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 >
|
|
#4
05-05-2005, 09:06 AM
|
|||
|
|||
|
Re: Pivot Table/Chart
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" <dsd@contexturesXSPAM.com> wrote in message > news:427981B2.1080007@contexturesXSPAM.com... > >>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
|
|
#5
05-05-2005, 10:06 AM
|
|||
|
|||
|
Re: Pivot Table/Chart
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" <dsd@contexturesXSPAM.com> wrote in message news:427A062B.7030705@contexturesXSPAM.com... > 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" <dsd@contexturesXSPAM.com> wrote in message >> news:427981B2.1080007@contexturesXSPAM.com... >> >>>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 >
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
