Macro to display specific cells

[Superlan]

Hi all,

please see attached my sample file. I need a button below the table, which I can use to display specific cells in the table. Meaning that when I click the button for the first time, the cells C4:F4 shall be displayed. The rest of the cells with a %-value have to be blank. When I click the button the second time, the cells C4:F5 shall be displayed and again the rest blank. The same for period 3 and 4. When I click the button for the 5th time and all clicks after that, all the cells should be displayed.

Can someone help me with that? That would be awesome.

[leelnich]

Hi Superlan-Have you ever worked with Filtering (Filter on the Data tab)? It may fit your needs.
PS You may want to consider switching your columns and rows, since there are probably more stocks than periods.

[Superlan]

Hi leelnich, my actual file consists of the exact same amount of columns and rows, so 4 stocks (columns) and 5 periods (rows). Filtering data would not help in that case unfortunately, I have to do it as explained above...

[leelnich]

OK. The nice thing about filtering is that the data is un-affected, it just hides the rows. Do you want to start with hidden rows and just expose them, or do you actually need to add data to previously-blank cells. If so, where does the data come from?

[Superlan]

The thing is that my data is connected to a chart and I only want to display the data for period 1 in the chart when I click on the button, then click again for period 2 so that the chart updates. Since I need the chart to be updated from time to time, I cannot just hide the data, because then the chart would still be drawn with all the data which is in the table, even though it's hidden.

Hence, I need to add data to previously-blank cells. If there is a way to still keep it to 1 table then this would be great. Otherwise maybe a solution would be to create another table with all the data, make the original one blank, and just pick the data from the created table?

Or maybe you know a better way to do it? Thanks for your help!

[leelnich]

Sorry, I have to go, but you might check out these links. The general idea is to use easily - or even automatically - changeable named ranges for your data series. I'll check back tommorrow:
Dynamic Charts
VBA-to-filter-chart-data-range/
Automatic-updating-dynamic-charts

[Superlan]

Ok so maybe it works then without a macro but with just changeable named ranges for your data series. I have attached a new example with a chart. Can you tell me how to do it with this chart, including the mentioned button I need to click on? Thanks!