Hi,
I am building an excel database with a lot of data that I will be updating daily. I need to generate charts from it as I update, so I am using pivot tables and charts. I also need the pivot table to organize the data properly.
The problem I am facing is that once the data is organized in the pivot table, I need to calculale the average of every 'n' items, i.e the average of the first 'n' items followed by the second 'n' items and so on and put it in a chart. I also need the calculate the range of the 'n' items. These are for X-Bar and R Statistics Charts.
So if anyone could help me with this, I would be really grateful. Thank you in advance.
I am building an excel database with a lot of data that I will be updating daily. I need to generate charts from it as I update, so I am using pivot tables and charts. I also need the pivot table to organize the data properly.
The problem I am facing is that once the data is organized in the pivot table, I need to calculale the average of every 'n' items, i.e the average of the first 'n' items followed by the second 'n' items and so on and put it in a chart. I also need the calculate the range of the 'n' items. These are for X-Bar and R Statistics Charts.
So if anyone could help me with this, I would be really grateful. Thank you in advance.
