Re: How to plot a line chart with custom y axis labels

[asgallant]

Using calculated columns in a DataView, you can do unit conversion.  This thread has an example of doing unit conversion (there's some more complicated stuff in there that deals with picking the data series to plot too, you can ignore that if you don't need it).

On Friday, November 16, 2012 8:04:48 AM UTC-5, Neil Thompson wrote:

I have plotted line chart showing weight loss/gain in kgs but some people, notably in the UK and US, would prefer to see the scale in stone/pounds.

Is there a way to provide the points to be plotted in kgs but show something else on the y axis points?

Thanks

Neil

[Neil Thompson]

Hi 

Thanks for the response but I don't think that this will work for stone & pounds simply because it is not a decimal value so you get 12st 13lbs then 13st 0lbs, 13st 1lbs etc. Ideally what I would like is to be able to plot using kgs but rewrite the y axis with the values in stone/pounds. Is that possible?

Neil

[asgallant]

Ahh, no you can't do that.