Peak Seagull
Member
Hi,
I’m hoping someone can help with an issue I have with creating a pivot chart from a pivot table.
If you look at the attached file you will see that I have created a pivot table on the ‘Project Issues’ tab from data contained in the ‘Issues’ tab. However, it does not show a one to one relationship in the ‘RAISER’ column between ‘RAISER’ and ‘OWNER’. Also, it’s only showing 8 items in the pivot table as opposed to 10 contained in the source data. When I try to create a pivot chart it shows no data at all.
Also, I can’t seem to be able to change the ‘DUE DATE’ in the other pivot table on the ‘Project Issues’ tab to show the year!
Hopefully, I’m just doing something silly and someone can tell me what I’m doing wrong.
Thanks for your help.
I’m hoping someone can help with an issue I have with creating a pivot chart from a pivot table.
If you look at the attached file you will see that I have created a pivot table on the ‘Project Issues’ tab from data contained in the ‘Issues’ tab. However, it does not show a one to one relationship in the ‘RAISER’ column between ‘RAISER’ and ‘OWNER’. Also, it’s only showing 8 items in the pivot table as opposed to 10 contained in the source data. When I try to create a pivot chart it shows no data at all.
Also, I can’t seem to be able to change the ‘DUE DATE’ in the other pivot table on the ‘Project Issues’ tab to show the year!
Hopefully, I’m just doing something silly and someone can tell me what I’m doing wrong.
Thanks for your help.