excel pivot charts

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - pivot charts, filtering out data points | Excel forum

Excel - pivot charts, filtering out data points | Excel forum

resolvedResolved · Low Priority · Version 2007

Emma has attended:
Excel Advanced course

Excel - pivot charts, filtering out data points

Hi. I am working on an Excel 'database' where I have 1 datapoint per row with multiple tags eg Rows 1 - 50 contain info for subject 1 where A1 = ID#, B1 = Gender, C1 = Parameter, (eg height, weight etc, D1 = value, (eg height score) etc etc Therefore for the first 50 rows only columns C and D change to indicate the changing parameter (height, weight, armspan etc) and their subsequent score. I am trying to create a pivot chart that graphs this data (easy to do). Less easy to do is include or exclude subjects in the chart based upon whether we have repeated scores on them or not.

We have 8 testing blocks within the dataset which are paired together. I can only include them in the chart if they have data in both 'pairs (pre and post)' eg if they attended testing block 1 but not 2 I can't include the data, but if they attended 3 and 4 I want to include that data (I hope this is making sense, ti isn't easy to explain!) In essence I think I am looking for a nested IFISBLANK command where I can perform some sort of check to see whether they have data in each testing pair and from that produce a filter which I can add into my pivot chart! I think this is a little more complicated than usual as our dataset runs vertically rather than horizontally and we now have 20,000 lines of data!

RE: Excel - pivot charts, filtering out data points

Hi Emma

Thanks for your question

In order to resolve this I would need to see a copy of the file. Could you email it to me (perhaps with dummy data if necessary) and I can try to resolve it for you

my email is sw@stl-training.co.uk

Regards

Stephen


 

Excel tip:

Seeing named ranges as part of the zoom

If you have large areas of named ranges this works better.

If you zoom down to 39% you will see your named range.

View all Excel hints and tips


Server loaded in 0.06 secs.