Help With Data Analysis/Pivot Table & Chart

tomohawk · #1 02-23-2023, 12:34 PM

Thanks for the support p45cal.

Is it possible you could explain the formula, so that I can learn.

Even a link to a page explaining it would be great.

Tommy

p45cal · #2 02-23-2023, 01:27 PM

Quote:

Originally Posted by tomohawk

Is it possible you could explain the formula, so that I can learn.

The only formula is in column D:
=COUNTIF([SO No.],[@[SO No.]])
This surely doesn't need explaining, but COUNTIF function - Microsoft Support

The rest is a standard pivot table & chart.
Column D is what groups the rows of data in the pivot.

tomohawk · #3 02-23-2023, 01:55 PM

Thanks again p45cal.

I can't find a reference as to why you use @ in the formula on the page that you linked to, so I would really appreciate if you could bear with me a little longer.

Tommy

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pivot chart for multiple data sets	md0627	Excel	1	01-08-2023 05:17 PM
Can we update Chart in PPT based on a table in the excel and the table is part of the Chart Data	nareshj	PowerPoint	0	07-12-2018 02:29 PM
Copying a Chart Linked to a Pivot Table	coma08	Excel	1	06-07-2017 08:24 PM
Combine multiple tables into one pivot table in order to do trend analysis	marelisev	Excel	2	04-15-2017 08:30 AM
Create PIVOT chart using few rows in pivot table	Santhosh_84	Excel	1	08-31-2015 06:22 AM