A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

1 curve , 2 units of measurement



 
 
Thread Tools Display Modes
  #1  
Old July 17th, 2007, 09:10 PM posted to microsoft.public.excel.charting
rastafl
external usenet poster
 
Posts: 1
Default 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

  #2  
Old July 17th, 2007, 09:32 PM posted to microsoft.public.excel.charting
Wigi
external usenet poster
 
Posts: 292
Default 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

  #3  
Old July 18th, 2007, 03:09 AM posted to microsoft.public.excel.charting
MartinW
external usenet poster
 
Posts: 848
Default 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



  #4  
Old July 18th, 2007, 11:08 AM posted to microsoft.public.excel.charting
Wigi
external usenet poster
 
Posts: 292
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.