Forum Discussion
Pivot chart not displaying all data from pivot table
Hi, I have created a pivot chart (clustered bar graph) and accompanying pivot table. However, the pivot chart is not displaying all of the data in the pivot table, it is only displaying every second row (i.e. 25 rows of data instead of 49). Is this because there is a limit to how many rows a clustered bar chart can display or could there be another reason? Many thanks.
2 Replies
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Hi HansVogelaar,
Thank you for your reply. I managed to fix the problem - it was actually because the bar graph has a limit to how many rows from the pivot table it can display; in this case it was 25 rows out of 50 (thus was displaying every second row only). I addressed this by creating two bar graphs; alternatively, if I increased the size of the bar chart, that helped too. Interestingly I could find nothing on the net about this issue!!
