Hi!
I was wondering if it were possible to align multiple axis in an excel chart to certain values.
Here is my chart:
excel chart.PNG
My left y-axis is %, while the right y-axis shows a value in grams.
What we want to focus on is the Light Blue shaded area. This is connected to the right y-axis measured in grams.
Is it possible to align the top of this Light Blue area, regardless of the value, with the 100% on the left y-axis?
In all of the charts we have like this, the max value of Light Blue area usually falls between 80-110% so I'm just not sure if there is a way to do this.
Please let me know if there is any more info needed!
Thanks!!!
Bookmarks