Hello Mr. Excel Users!
I am doing an excel assignment, and it is creating some serious troubles for me.
A little intro:
So our pivot table down below is showing "Sales", "Best Months", "Worst Month". The blue area to the right is deciding how many good or bad months we want to show.
The way i hide the data in "Best Months" and "Worst Months" is by making a conditional formatting with the custom format ";;;" .(Can this be done any better when dealing with pivot tables?)
And heres the problem: Our teacher wants the graph to look like the one below. (Dont mind that the data is in different months) The important thing here is that i only want to show data labels for the 4 good months and the 4 bad months. But i can't get rid of the conditional formatting hidden values. Any suggestions? I have tried a lot of different things for that past few hours. But without any luck.
Best Regards,
Simon Frandsen.
I am doing an excel assignment, and it is creating some serious troubles for me.
A little intro:
So our pivot table down below is showing "Sales", "Best Months", "Worst Month". The blue area to the right is deciding how many good or bad months we want to show.
The way i hide the data in "Best Months" and "Worst Months" is by making a conditional formatting with the custom format ";;;" .(Can this be done any better when dealing with pivot tables?)
And heres the problem: Our teacher wants the graph to look like the one below. (Dont mind that the data is in different months) The important thing here is that i only want to show data labels for the 4 good months and the 4 bad months. But i can't get rid of the conditional formatting hidden values. Any suggestions? I have tried a lot of different things for that past few hours. But without any luck.
Best Regards,
Simon Frandsen.
