Hi Forum,
The tab named “Sheet1” in the attached Excel file is having my input data.
Using this data, I wanted to create 3 graphs to show how the % values of firm 1 and firm 2 behave in each quarter by 3 different cycles.
I have created a pivot chart in tab named “Sheet2”.
Q:
Blue line in the graph (for Firm_1) is correct.
But red line (Firm_2) is not correct. Red line looks like showing the combined values of (Firm_1 + Firm_2).
Could you let me know how to correct the red line to correctly reflect its values which are 23%, 35%, 14% and so on.
Thanks
Mirisa
Bookmarks