Thread: Easy to use graph production

Hi there,

I have a sheet which contains apple production at different bases. I want to create a nice way to present the data to people who uses the sheet. I would like the data to be shown in such a way that the plan, actual and differences are shown in one graph and this one graph should update with different base's data when a different base is selected. Like in a pivot table for example.
I tried using a pivot chart and I could not get the data to show what I require. Can anyone suggest a way to do such a thing if so, how?

Cheers.