SCROLLABLE CHART AND EASY FORMULA

[blazy]

Hey Excel gurus,

I need help. I need scrollable chart help and help with one easy formula. Everything is explained in the attached file.

Please help, thank you!

 

[Somendra Misra]

Hi Blazy,

How many months you want to show together on the chart and than when scroll how much shift you want?

Can you post a sample chart showing how it should look like?

Regards,

 

[blazy]

Hey Somendra,

shift for 1 month, together show around 10 months, it is not really that important how many as long as it looks ok. I would just like it for upcoming months if the chart can be dynamically updated when I insert the data in the table...

I would want something like this in attached photo (but for two lines, so two lines for 908a and 911a, the third is objective (vertical line is at 100 %).

Thanks!

 

[Somendra Misra]

@blazy

Can you check back in some hour.

Regards,

 

[blazy]

Sure, thanks!

 

[Somendra Misra]

@blazy

I understand your row data on green range of row 51 is months, but how are you going to add data to this table?

Regards,

 

[blazy]

Hey,

I will add that data manually, I will add columns to the right when new year and new months are coming.

Blazy

 

[Somendra Misra]

@blazy

See the file, I had added named range to plot graph and added a sheet for chart data, go through the same and write back if this is OK.



Regards,

 

[blazy]

thanks once again Somendra! Works great!