ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   1 curve , 2 units of measurement (https://www.excelbanter.com/charts-charting-excel/150612-1-curve-2-units-measurement.html)

rastafl

1 curve , 2 units of measurement
 
Is it possible to have an alternative uM on the secondary axis on the same
curve?

Help!

--
Peace and Love,

cw


Wigi

1 curve , 2 units of measurement
 
Hi

I've got an example sheet on my website.

Go to my website, http://www.wimgielis.be, then choose
Excel in the left navigation, then choose Voorbeeldbestanden, then choose
"Dubbele grafiekas" (it's below "Excel grafieken")

Download the example file on that page.

The file plots the average speed of the world records in athletics, for men
and women, as function of the distance.

By the way, did you know that the average speed over 200 meters is higher
than that over 100 meter? (the effect of the start is smaller)


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"rastafl" wrote:

Is it possible to have an alternative uM on the secondary axis on the same
curve?

Help!

--
Peace and Love,

cw


MartinW

1 curve , 2 units of measurement
 
Hi Wigi,

Did you know that 1 in 10 men have some sort of color weakness
and 1 in 100 are colorblind or more accurately defined as color vision
deficiency.

I'm one of the 1 in100, what is known as red/green colorweakness. This
doesn't
mean that I don't see in color, it just means that certain shades blend in
with
one another.

For instance the two lines on your "Dubbele grafiekas" chart appear to be
the
same to me on screen. When I print it out and put it under a bright light I
can
see that one is in fact green and the other red. (I think!!!) <g

Although it is defined as red/green it is not limited to those colors,
purple and blue
are almost indistinguishable to me even under bright lights, and as for
black writing
on a red background, well, I gave up trying to read that years ago.

It is very helpful to people like myself if people are aware of this when
they are
color coding things. In general terms stark contrast is the best way to go
although
it's not that simple because what you would consider to be a stark contrast
I
wouldn't. Sticking to true colors rather than subtle shades is also very
helpful.

Don't get me wrong Wigi, I'm not complaining. It's just that the only way
that
myself and others like me can help ourselves is by educating those around
us.

If you click on this link http://en.wikipedia.org/wiki/Color_blindness
and look at the color patches down the right hand side you should get
more of an idea of what I am talking about. The closest to what I see
is the one for deuteranopia.

Actually I find my color weakness to be an asset, the situations that can
arise
and the ensuing conversations can sometimes be hilarious. Like the time
I bought this great looking pale blue jacket as a birthday present for my
brother. He still wears it to this day and whenever any one asks him
why he is wearing a Hot Pink jacket he tells them that it is pale blue
and they should go and get their eyes checked.

Have a happy colorful day
Martin



"Wigi" wrote in message
...
Hi

I've got an example sheet on my website.

Go to my website, http://www.wimgielis.be, then choose
Excel in the left navigation, then choose Voorbeeldbestanden, then choose
"Dubbele grafiekas" (it's below "Excel grafieken")

Download the example file on that page.

The file plots the average speed of the world records in athletics, for
men
and women, as function of the distance.

By the way, did you know that the average speed over 200 meters is higher
than that over 100 meter? (the effect of the start is smaller)


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"rastafl" wrote:

Is it possible to have an alternative uM on the secondary axis on the
same
curve?

Help!

--
Peace and Love,

cw




Wigi

1 curve , 2 units of measurement
 
Thank you for "educating" me Martin. I will try to remember for the future.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"MartinW" wrote:

Hi Wigi,

Did you know that 1 in 10 men have some sort of color weakness
and 1 in 100 are colorblind or more accurately defined as color vision
deficiency.

I'm one of the 1 in100, what is known as red/green colorweakness. This
doesn't
mean that I don't see in color, it just means that certain shades blend in
with
one another.

For instance the two lines on your "Dubbele grafiekas" chart appear to be
the
same to me on screen. When I print it out and put it under a bright light I
can
see that one is in fact green and the other red. (I think!!!) <g

Although it is defined as red/green it is not limited to those colors,
purple and blue
are almost indistinguishable to me even under bright lights, and as for
black writing
on a red background, well, I gave up trying to read that years ago.

It is very helpful to people like myself if people are aware of this when
they are
color coding things. In general terms stark contrast is the best way to go
although
it's not that simple because what you would consider to be a stark contrast
I
wouldn't. Sticking to true colors rather than subtle shades is also very
helpful.

Don't get me wrong Wigi, I'm not complaining. It's just that the only way
that
myself and others like me can help ourselves is by educating those around
us.

If you click on this link http://en.wikipedia.org/wiki/Color_blindness
and look at the color patches down the right hand side you should get
more of an idea of what I am talking about. The closest to what I see
is the one for deuteranopia.

Actually I find my color weakness to be an asset, the situations that can
arise
and the ensuing conversations can sometimes be hilarious. Like the time
I bought this great looking pale blue jacket as a birthday present for my
brother. He still wears it to this day and whenever any one asks him
why he is wearing a Hot Pink jacket he tells them that it is pale blue
and they should go and get their eyes checked.

Have a happy colorful day
Martin



All times are GMT +1. The time now is 02:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com