I have a chart with monthly data and yearly cummulative data. I would like to have the chart display data so that the monthly data is not shrunk on the chart, E.g. months
Months Value Cummulative Value
1 6 6
2 5 11
3 7 18
I want to display the chart with both values for Value and Cummulative Value but since the cummulative value grows much faster and can shrink the Values displayed on the chart, i would like to set a custom scale for part of the chart to display the values. Then i would like to reset the scale to display the cummulative Values. How can i do this?