Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
dual units? 9
- Thread starter HgTX
- Start date
If you don't get a better answer, you could always take an image output of the chart and graphically edit it. It would only take a few minutes.
This assumes that the final output is something (like a report) where an image will be perfectly acceptable.
This assumes that the final output is something (like a report) where an image will be perfectly acceptable.
-
1
- #3
Kind of a pain, but I can't think of a better way.
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.
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.
- Thread starter
- #4
VE1BLL:
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
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
- Thread starter
- #6
FalsePrecision
Structural
This may be getting off topic, but the problem is, Excel hasn't really evolved in a constructive direction - maybe if QuattroPro had more clout in the marketplace, we would have a better spreadsheet.
-
1
- #10
btrueblood
Mechanical
I was gonna say, this is pretty easy to do. Just plot a second series consisting of the converted units at the max & min. ends of the range to be plotted, and plot this new series on a "secondary axis". Format the series to turn off its plotting (click the radio buttons for "no line" and "no marker", then click on the series name in the legend (if used), and press delete.
- Thread starter
- #11
Having now played with the secondary axis concept, I now realize I need dual units for both axes. As far as I can tell, secondary axis is only good for the Y axis. Or am I missing something?
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
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
btrueblood
Mechanical
HgTx,
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.
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.
"...my pathetic array of Microsoft software will let me superimpose images."
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).
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).
- Thread starter
- #14
-
1
- #15
I have a similar problem in some of my calculations so I set up the axes with non-specific characters (Like A..B..C etc or I ..II..III you get the idea). Then, after locating the graph on the spreadsheet, I put a couple of columns on the side and rows on the bottom which contain the real numbers. They are almost adjacent and not difficult to decipher. With a little thought and time you can actually juggle the row and column sizes to match excatly, but thats not really needed.
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!
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!
btrueblood
Mechanical
Well, there's always the old ink pen and straight edge technique...now, where's my straightedge...and where's my good drafting pen...and the ink is all crusty and dried...hmmm. Maybe some mac-tac, but the gal at the office supply store gave me a funny look when I asked...
-
4
- #17
flamby
Structural
- Feb 12, 2002
- 591
At least for X-axis problem...
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.
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.
-
1
- #18
![[cheers]](/data/assets/smilies/cheers.gif "[cheers] [cheers]")
HgTX,
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.
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.
-
1
- #20
HgTX,
If you haven't given up yet, or worked out a solution you should go to 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
If you haven't given up yet, or worked out a solution you should go to 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
- Status
Similar threads
