excel chart dynamic range based on values
Posted
by
andrewk
on Super User
See other posts from Super User
or by andrewk
Published on 2012-12-18T19:19:09Z
Indexed on
2012/12/20
5:05 UTC
Read the original article
Hit count: 470
I'm trying to create a chart that auto updates itself from a data provided. The range of the chart is always fixed/locked
. The issue I'm facing is that when a value for a certain month is 0, I want it to skip to the last non-zero month . Meaning the ranges selected forming the chart should exclude the month with the value zero. Which in most cases is the top month.
The image below should clear it up.
Is there a way to have the chart range be dynamic based on certain values?
© Super User or respective owner