Show Values in KG and LBs

[Guest]

I have a line chart consists of 4 data series. I'm showing weeks on one axis
and production vlaues in another axis. I would like to show the production
values in both Kg and Lbs at the same time, but I don't want to show 8 lines
just 4 lines. I would like to show one set of values (LBS) on the inner side
while (KGs) on the outer side of the 'Y' axis. But if that not possible i'm
open to have a secondary axis.
My data is arranged in columns, while these columns are not next to each
other, every Kg column has a LBs column next to it. I'm thinking of inserting
a CONVERT formula somewhere in the data series to show the same data twice.
Once in KGs and another in LBS, but I don't how to go about doing that.


Any help is greatly appreciated.

Thanks.

 

[Guest]

I'd do something like Jon shows in his vertical category axis article

http://www.peltiertech.com/Excel/Charts/Y_CategoryAxis.html

I'd have a helper column with the x value as your minimum x value for the
chart and the y values as 1 KG, 2 KG, 3 KG ... (whatever).

You could then use Rob Bovey's XY Chart Labeler to put the labels on the
chart and locate them where you want.

 

[Guest]

Thanks Barb, but I think the link you have provided is a little different
from what i'm aiming for. Basically I would like to show the 'Y' values in
both Kgs and LBs side by side or on both primary and secondary axes. I
managed to plot my Kgs on the left and my LBs on the right, but I couldn't
get to have the Lbs values correspond to the Kgs values on the same tick
mark. Example: when I show 400 KG on the left, I would like to show the
equivalent of that value in LBs (881) on the same line/tick mark on the
right. I have forced my scales on both axes to start at zero, then I
converted my max Kg value into Lbs and used that as my max value for the LBs
axis, but the values in the middle don't match. I can care less about the
labeling at this point.

Hopefully someone would have an idea on how to do this.

Thanks.

 

[Guest]

Sahafi,

This example shows how to calculate a proportional primary and secondary
axis. The method will allow you to line up your tick marks.

http://www.cellmatrix.net/index.php/site/comments/proportional_axis_calculations/

 

[Guest]

Thanks John. I will look into your example.

Temporarily, I have utilized a simple solution: plot the original values in
KG then add a secondary dummy 'Y' for the LBS. Convert the Min and Max KG
values into LBs. Then convert the 'Major unit' from KG into LBS as well. Once
you add the converted Major unit into LBs the rest of the secondary axis
values will adjust accordingly to match their corresponding KG values on the
same tick mark. Then click on the dummy series and remove line and mark to
get rid of the extra line. That's it!

Thanks.