Re: Pivot table data filter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Neil

Regrettably, i am not fully understanding your problem.
If you want to mail a copy of the workbook directly to me, I will take a
look and see if I can achieve what you want.
To mail direct, remove NOSPAM from my address.

--
Regards

Roger Govier


"Neil" <Neil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F2534FB1-7EA8-45FF-B794-40A29D8A9ABD@xxxxxxxxxxxxxxxx
Hi Roger thanks for the reply

It does work in that i can reselect them if i de select them but i
have
four different fields that i want to maybe just look at 2 or 3 at a
time to
compare them. If i put the field in the data and the Row i can only
deselect
certain results of the field not all of it. With it being in the data
bit on
the right of the chart i can compare all the results for all the
fields in a
line chart this is against week numbers in the row. i just remove and
replace
the different fields but they don't appear again! Sorry if this sounds
a bit
muddled but thanks anyway.

"Roger Govier" wrote:

Hi Neil

If you de-select a field from the Data area, it is removed totally,
and
you have to drag it back in again.

Try adding the field to the Row area, AND to the Data area.
Use the dropdown on the Row filed to select or deselect the items.

--
Regards

Roger Govier


"Neil" <Neil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D4343C16-F7D5-44B2-A25C-84A5F1C326E2@xxxxxxxxxxxxxxxx
I have a pivot table with matching chart. I used the layout function
to
get
it how i want but in the data section there is 2 types of data.
They
apear
fine and i can read them and see them in the chart ok, but if i
want
to
select just one to see it on its own i can , but the one i didn't
select the
option is missing from the list. Taking the data out. Both sets of
data are
set as Sum, but on other pivot tables i have done in the past this
has
worked
when i have been using count.

Any ideas

Thanks





.

Relevant Pages

  • RE: macro for graphs
    ... If I understand your question you would like to change the chart by pressing ... Set up one data area for charting. ... In cell I1 add a data validation dropdown with the list option selected. ... All the graphs will be the same format ...
    (microsoft.public.excel.charting)
  • Re: Binding OWC11 Chart to Pivot table
    ... This looks like another bug. ... additional fields to the data area it is not reflected in the chart... ... if i drag a field to the data area of a chart it IS ...
    (microsoft.public.office.developer.web.components)
  • Re: Binding OWC11 Chart to Pivot table
    ... Professional VSTO 2005 - Wrox/Wiley ... additional fields to the data area it is not reflected in the chart... ... if i drag a field to the data area of a chart it IS ...
    (microsoft.public.office.developer.web.components)
  • Re: Date Calculation Problem
    ... then you could use the following formula in cell D2 copied across and down ... Roger Govier ... I've tried this over a longer period and I can only get the formula to ... indicated every fourth week on the chart, as my chart goes several months ...
    (microsoft.public.excel.worksheet.functions)
  • Re: If in a formula .. or a better way?
    ... I put this formula in cell L2 and copied down ... A chart will recognise #N/A as no data available for that period. ... Roger Govier wrote: ...
    (microsoft.public.excel.misc)