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.
--
If u change the way u look @ things, the things u look at change.