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

excel pivot charts

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

Excel - pivot charts, filtering out data points

ResolvedVersion 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:

Page Break Preview in Excel 2010 (Hint/tip)

If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.