dual units?
dual units?
(OP)
Anyone know of a way to put both metric & english axis labels on an Excel chart? Like for example inches down the left side and mm down the right?
(did SigmaPlot do this? does anyone still use SigmaPlot?)
Hg
(did SigmaPlot do this? does anyone still use SigmaPlot?)
Hg





RE: dual units?
This assumes that the final output is something (like a report) where an image will be perfectly acceptable.
RE: dual units?
Make a new column for your alternate units and populate it with the new numbers.
Plot the alternate units as a new series on the secondary axis.
Play with axis scaling until the two curves overlap.
Change the color to one of the curves to invisible.
RE: dual units?
I was *so* hoping not to have to do that...but yeah, this whole thing is gonna be exported elsewhere.
I suppose one way would be to generate two separate charts, identical except for axes, and then superimpose the images. That would make sure that everything lines up right. (Not that I think anything in my pathetic array of Microsoft software will let me superimpose images.)
I'll try to try what MJ suggests & report back, if I have the brains for it today.
Hg
RE: dual units?
I looked into this, because I wanted to make design nomographs.
The only programs that are out there are high end--and thus hard to use--I gave up on the idea.
RE: dual units?
Hg
(sorry, couldn't resist)
RE: dual units?
RE: dual units?
f you graph more that 1 curve, you can select a secondary y-axis, which then allows you to label both y-axes separately.
TTFN
RE: dual units?
RE: dual units?
RE: dual units?
I think I'm going to give up, stick with one set of units, and let the publishing people figure out how to get the equivalents in there.
Feh.
Hg
RE: dual units?
You could fake a pretty good secondary X-axis by plotting a "+" symbol marker along a line slightly offset from the origin. The symbols would be plotted from a series of converted data at whatever increment you wanted.
RE: dual units?
Even the lowly MS-Paint allows one to superimpose images (there's two buttons - overlay or superimpose). It shouldn't take more than a few minutes to prepare an absolutely pixel-perfect image for export (to MS-Word for example).
RE: dual units?
Hg
RE: dual units?
I use the same technique when using the same physical presentation for differing input variables. It means just a little extra cell progamming (IF statements etc) but it's very convenient to read when it's done and it makes the presentation idiot-friendly.
You could also try the same thing with the area pattern set to none. (Double click the background to open the dialogue box). Then you can move the graph over the data cells so that they show through and avoid the A.B.C altogether. You need to play with this a little to get the hang of it. Be creative!
RE: dual units?
RE: dual units?
1. First column - values in mm
2. Second column - convert the first to inches, round to 2 decimal precision.
3. Third - =CONCATENATE(A1,"(",B1,")")
WIll appear like 10(0.39).
You can plot this text mm(inch) in X axis as labels.
Ciao.
RE: dual units?
RE: dual units?
Three things that may be of help:
1. Once you have a secondary Y-axis set up, you can select Chart/Options from the menu, and go to the Axes tab. Magically, you are now allowed to tick also the Secondary Value (X) axis!
2. If you - at some point - want two overlapping charts, the way to do it is to place the "background" chart into a chart sheet (Chart/Location - Place chart as new sheeet)
and then place the second chart "as object in Chart1"
3. If you have a mix of a chart and a scanned image (for example), you can select the chart area, and then format the fill pattern with the Fill Effects button to show a picture, which can be any image file.
Good luck experimenting.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: dual units?
If you haven't given up yet, or worked out a solution you should go to http://peltiertech.com/ and take a look at his chart stuff. You'll find something about tertiery axes. This will do what you want I'm sure. I've used it and it's pretty simple. You'll have to download some labeling addins, but all of the information is there.
Clyde