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 ...
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!!
