T
Thiem
I am using a line chart, where the chart results are driven by a
validation list. So when I choose a specific product, up come sales,
forecast and ajusted forecast for the product.
Seeing that we are not living in a perfect world, the acuals differs
quite by a huge amount depending on the product.
What I want to achieve is to set the Major Axis (Y Axis) value to 20 %
or a fifth of the total value, as I want only 5 gridlines in my
charts.
I have linked my Chart Title a to a cell (Validation Cell, so chart
title = product name), but I cant seem to ink the Y axis major value to
a cell. Is this possible, if so, is there somebody who can assist me
with my request.
Thanks to ever is willing to lookat this request.
Thiem
validation list. So when I choose a specific product, up come sales,
forecast and ajusted forecast for the product.
Seeing that we are not living in a perfect world, the acuals differs
quite by a huge amount depending on the product.
What I want to achieve is to set the Major Axis (Y Axis) value to 20 %
or a fifth of the total value, as I want only 5 gridlines in my
charts.
I have linked my Chart Title a to a cell (Validation Cell, so chart
title = product name), but I cant seem to ink the Y axis major value to
a cell. Is this possible, if so, is there somebody who can assist me
with my request.
Thanks to ever is willing to lookat this request.
Thiem