Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 02-23-2023, 01:27 PM
p45cal's Avatar
p45cal p45cal is offline Help With Data Analysis/Pivot Table & Chart Windows 10 Help With Data Analysis/Pivot Table & Chart Office 2019
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by tomohawk View Post
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.
Reply With Quote
 



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
Help With Data Analysis/Pivot Table & Chart Create PIVOT chart using few rows in pivot table Santhosh_84 Excel 1 08-31-2015 06:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft