maudrenetan
New Member
Dear all,
I have been searching around for a solution to my problem, but have yet to find a suitable solution.
I have a set of data that has been collected across several groups over 6 quarters. I have calculated the average across the groups and will like to be able to compare against the average, as well as across groups. Hence, clustered columns are the preferred chart-type. However, there is a static target line that I'll like to plot onto the pivot chart to show how the groups are doing relative to the target. The problem starts here. When I try to filter to select the groups that I'm interested in, the formatting that I've initially set gets messed up.
Method 1 (tab mtd 1):
I included the target line as a column in my data set. Then I used a combo chart to select clustered columns for my groups and target line into "line" chart. However, when I tried to filter for specific groups, my formatting gets messed up.
Method 2 (tab mtd 2):
I included the target line as a "group" in my dataset. Again, I used a combo chart. However, the same formatting problem occurs.
How can I keep the "target" in line format and my groups in "clustered columns" and not have this format messed up when I select groups of my choice? Can anyone help me with this? I have attached a sample data that I had created (both mtd 1 and mtd 2) to help everyone understand how my data is like.
Many thanks.
Warmest regards,
Maudrene
I have been searching around for a solution to my problem, but have yet to find a suitable solution.
I have a set of data that has been collected across several groups over 6 quarters. I have calculated the average across the groups and will like to be able to compare against the average, as well as across groups. Hence, clustered columns are the preferred chart-type. However, there is a static target line that I'll like to plot onto the pivot chart to show how the groups are doing relative to the target. The problem starts here. When I try to filter to select the groups that I'm interested in, the formatting that I've initially set gets messed up.
Method 1 (tab mtd 1):
I included the target line as a column in my data set. Then I used a combo chart to select clustered columns for my groups and target line into "line" chart. However, when I tried to filter for specific groups, my formatting gets messed up.
Method 2 (tab mtd 2):
I included the target line as a "group" in my dataset. Again, I used a combo chart. However, the same formatting problem occurs.
How can I keep the "target" in line format and my groups in "clustered columns" and not have this format messed up when I select groups of my choice? Can anyone help me with this? I have attached a sample data that I had created (both mtd 1 and mtd 2) to help everyone understand how my data is like.
Many thanks.
Warmest regards,
Maudrene