Dynamic Charts (Last 12 months)

Stuck1

Board Regular
Joined
Sep 3, 2009
Messages
73
Hi all,

I wondered if there is a way of creating automated charts without using dynamic ranges? In the past I've used formula similar to Chart the Last 12 Months Dynamically but this time I have a lot more datasets to plot and creating all the range names will take a while.

The data I have is in rows (goes along) rather than columns (goes down). I want to be able to select a month from a drop-down and then I want the chart to show the last 12 months for the data. E.g. If I select December 2016, I'd like to see January 2016 to December 2016. Ideally I'd also like to handle the circumstance where there are fewer than 12 data points.

Hope someone has a solution. Please let me know if you require more information.

Thanks for any help.
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top