• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Then vs Now Interactive

Alan Graham

New Member
Hi New poster and fairly recent visitor to this awesome site.

I have adapted the Interactive Chart - http://chandoo.org/wp/2013/08/06/how-to-create-a-then-vs-now-interactive-chart-in-excel/ to use month against previous month.

Im wondering if it would be possible to have the choice of what months are compared to each other.

So rather than having January v Feb, I could select January V March or whatever 2 months I choose to compare?

Any and all help would be appreciated?
 
Alan

Firstly, Welcome to the Chandoo.org Forums

Yes, what you want is possible

Simply add an intermediate range that sources the data for the chart by using an Offset or Index, these will be linked to a Control that allows you to change the selection

The easiest way to demonstrate is if you post your file here and we can add that to your data
 
Hi Hui,

Thanks for your very quick response.

I have attached an example of what I have set up already.

Thanks once again
 
Hi Narayank991,

Yes this appeals.

Can you demonstrate how i would set this up?

Apologies but I'm in now way an Excel expert
 
Thanks for your help. I will need to look at this at home as work isnt letting me download the file.

Will get back to you once I have a look.

Again thanks
 
Back
Top