Is it possible to create custom Y-axis labels?
I am creating a chart for weight loss tracking for UK stones and X-axis is days, Y-axis is weight.
I am already changing the Y-axis minimum and maximum values based on the user entered starting weight with:
ActiveSheet.ChartObjects(1).Chart.Axes(xlValue).MaximumScale = w_top
ActiveSheet.ChartObjects(1).Chart.Axes(xlValue).MinimumScale = w_bottom
I'd like to display Y-axis as 10 st 12 lbs, 8 st 13 lbs etc.
Is this possible.
I am creating a chart for weight loss tracking for UK stones and X-axis is days, Y-axis is weight.
I am already changing the Y-axis minimum and maximum values based on the user entered starting weight with:
ActiveSheet.ChartObjects(1).Chart.Axes(xlValue).MaximumScale = w_top
ActiveSheet.ChartObjects(1).Chart.Axes(xlValue).MinimumScale = w_bottom
I'd like to display Y-axis as 10 st 12 lbs, 8 st 13 lbs etc.
Is this possible.