METRIC wb performance curves

[BillA]

after considerable feedback from the rad article re metric/SI units,
I'm thinking to make the (pending) wb one in SI units
(for those that read graphs) here is an example

for the lowly Cooltech WB75:







unfortunately, not having grown with these units, I have no 'feel' at all for the magnitudes in this graph



while this is just fine (for me)

for all the commentary that has gone on about C vs. F, does the same not apply to liters ?

comments/suggestions ?

[bigben2k]

That's a good question.

I think that what it comes down to, is what's standard, but since your audience is from different countries where the standards are different, it would be best to post results with both standards.

But you don't want to post two graphs showing the same results, so you'd have to come up with a way to use the horizontal scale at the bottom as english measurements, and the top horizontal as metric, and the same for the vertical axes (left: english, right metric). You'd also need a line for the metric measurements with regular cross marks.

The thing is, you'd be hard pressed to trick Excel into doing this.

You need a program that can do that for you. Got any VBB skills?

[BillA]

VBB not spoken here
I even have access to Tecplot - but not the time to master it
anyone familiar with it ?

[bigben2k]

Here's an MS-Paint hack job (I didn't complete the right side).

[utabintarbo]

Originally posted by bigben2k
That's a good question.

I think that what it comes down to, is what's standard, but since your audience is from different countries where the standards are different, it would be best to post results with both standards.

But you don't want to post two graphs showing the same results, so you'd have to come up with a way to use the horizontal scale at the bottom as english measurements, and the top horizontal as metric, and the same for the vertical axes (left: english, right metric). You'd also need a line for the metric measurements with regular cross marks.

The thing is, you'd be hard pressed to trick Excel into doing this.

You need a program that can do that for you. Got any VBB skills?

Actually, I think Excel can do this. Something to look into...

Bob

[BillA]

Bob
really ?
got a 'click' sequence to get into the setup for such ?

(a side note: I am continually impressed with the capabilities of Excel for such a relatively inexpensive program; can't understand all the badmouthing of M$)

[utabintarbo]

Originally posted by unregistered
Bob
really ?
got a 'click' sequence to get into the setup for such ?

(a side note: I am continually impressed with the capabilities of Excel for such a relatively inexpensive program; can't understand all the badmouthing of M$)

I know I've seen this done. I can't figure out how to do it right now. It might have been an add-on component. I'll look into it.

Bob

[pHaestus]

If Excel can't do it then a package that I use for work (Microcal Origin) certainly can. It might be pricey for non-academic use; let me see if I have an older version lying around that isn't installed anywhere.

[pHaestus]

http://csssrvr.entnem.ufl.edu/~walke.../06cXLtips.pdf

This may somewhat work.

[BillA]

hummm
close, but no cigar

in a (too ?) quick run-through it seems this (the inst at the top of pg 2) is to superimpose two data sets having different values wrt the y axis
- kill the second dataset and the second scale goes away also;
and no second values can show on the x axis

I really would like to find a way to do this 'natively', as Photoshop (in which I am NOT qualified) always seems to result in image degradation

[pHaestus]

Yes photoshopping I would avoid as well.

The 2 axis link doesn't work if you use two sets of data with the same X axis in both?

Origin is easy. It takes excel spreadsheets as input files so no extra work other than doing the graphing. I would also be happy to reconstruct the graphs for you in that program if you don't want to mess with it.

[pHaestus]

I looked around and it SHOULD be possible in Excel. This book:

http://search.barnesandnoble.com/tex...sbn=0471394629

at least advertises charts with multiple axes in Chapter 5.

Maybe the local Barnes and Noble would have it? A good cup of coffee and a flip through the book wouldn't be so awful on a Sunday. I used to solve specific php coding issues that way

[BillA]

there are so many graphs - tolerable,
with SO many revisions - really intolerable (but also quite necessary for GOOD results);
don't wish to lose that welcome mat

but thanks

raining pitchforks and hammer handles right now, I'll try to hit B&N next week

origin ?

[pHaestus]

hrm the Excel help pulled up this:

"Add a second axis
When the range of values for different data series in a 2-D chart varies widely, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series.

Click the data series you want to plot along a secondary value axis.
On the Format menu, click Selected Data Series, and then click the Axis tab.
Click Secondary axis."

I suspect you've tried this with 2 sets of data (one metric and one english) already though.

[utabintarbo]

You can also check this MS KB link:

http://support.microsoft.com/default...;en-us;Q214011

Bob