Graph Data on for the current month

Hi All,

I am trying to create a "dynamic" graph which will allow me to change the information shown based on what month it currently is.
So if cell A2 changes from August to February, the graph will automatically update and show the February breakdown instead of the August breakdown.

I have attached an example of what I am using, and 2 graph to show what I am after.

Ta muchly for any help provided.

I see that you are using the EX 2013 version so the fastest I would do with Power Query. The data (after transforming your table) is returned to the memory and not to the sheet.
Based on this data, I created two pivot tables and then charts.

Hi BSB,

I think you may have uploaded the wrong sheet? Data is very different and there is no graph included.
Are you able to check and upload the correct sheet.

Ta,

matt

Hi guys,

Thanks for the help. I've ended up slightly changing the way to select the information that I am after.

I've decided to add on the graphing tab a quick reference for the current month and do an index match to pull across and show only the information which is relevant to the current month selected.
I've attached the example.

Originally Posted by Vibro

I think you may have uploaded the wrong sheet? Data is very different and there is no graph included.

You are correct. Apologies for that. Bound to happen occasionally when helping so many people....

Correct version now attached. It does what you need and negates the need for the additional sheet, although obviously ignore if you've decided to go with your version.

BSB

Thanks, I might use this instead, safes the leg work on the other idea.

Happy to help

BSB