Incorrect values on pivot chart???help!!!

U

ultrasounds4u1

I have a pivot chart with the names/technicians/codes...When I change to the
month of July it only shows like three patients. I have approximately 200
entered in. It appears to work fine for all other months. It just will not
work for this one. I have had alot of trouble with the grouping feature for
the months to try to show what is happening per technician, per doctor, per
month...Any suggestions?
 
D

Debra Dalgleish

Does the pivot table source range include all the July rows of data?
To check, right-click on a cell in the pivot table
Click PivotTable Wizard
Click the Back button to go to Step 2
Check the data range, and expand it if necessary.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

show results of two pivot charts 3
Pivot table creates stacked column 2
1 for Debra? - Pivot Chart calculated field? 3
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Stacked column with additional single bar chart 2
kind of chart? 1
Getting line on line chart to display after creation from Pivot Table 8
How to include the Grand Total Column in a pivot table chart? 1

Top