hmmmidk220
Board Regular
- Joined
- Dec 14, 2016
- Messages
- 55
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
4% | 5% | 4% | 2% | 3% | 4% | 5% | 0% | 0% | 0% | 0% | 0% |
<tbody>
</tbody>
Hi!
So I have a line chart linked to the above table. Each cell of data in the table gets it's % from the database each month. When the database is refreshed , the new month populates and the % goes from 0 to whatever it is. Each month the chart data has to be manually adjusted to look at the new month, and can't look at it all of the months because the months' without data yet (0%) will mess up the chart.
So I've seen solutions with dynamic ranges/tables and offset formula, but I'm not sure how to make it work in this case.
Also, since the % could be zero for a month that we have data for, I would at some point use an if statement to make future months (which will say 0% too) say something else such as blank, because otherwise I don't see how the chart could filter those out. Ignore this part if it doesn't make sense. How would I go about making this chart dynamic?
Thanks!