# embedded chart- Secondary Y axis

• 02-21-2013, 01:21 PM
Truman
embedded chart- Secondary Y axis
Does any one have an example of using a secondary Y axis in an embedded chart on a form?

Thanks
Truman
• 02-21-2013, 02:00 PM
Keith Hubert
Re: embedded chart- Secondary Y axis
Hi Truman,

What sort of chart are you trying to build?
• 02-21-2013, 02:58 PM
Truman
Re: embedded chart- Secondary Y axis
Quote:

Originally Posted by Keith Hubert
Hi Truman,

What sort of chart are you trying to build?

A simple line chart. One example of what I am trying to do is a golfer's example. I am plotting golf score and average driving distance. If you golf you would know that I hope that the units on score and driving should be different - in my case the difference in not too great. In my dream world my golf scores would be in the 'eighties and my drive average would be over 200 yards. I would like one Y axis to have the golf score values and the other Y axis to have the driving distance.

Thanks
Truman
• 02-21-2013, 03:32 PM
Keith Hubert
Re: embedded chart- Secondary Y axis
Truman,

If the y axis is the score, then the Distance would be the x axis.
• 02-22-2013, 08:23 PM
Truman
Re: embedded chart- Secondary Y axis
Quote:

Originally Posted by Keith Hubert
Truman,

If the y axis is the score, then the Distance would be the x axis.

Hi Keith

Sorry for the delay in replying. What I am trying to do is get a visual impression of whether average score is correlated to average drive distance, or number of putts or any other metric. The problem is that is the numbers are of a different magnitude. It is hard to see a relationship between the two measures because the smaller valued item appears to be relatively flat relative to the larger valued item.

I will provide a visual example in the next few days. I am not sure if I should provide the URL, or a scree shot, or jpeg of an example. I will work on that in the next couple of days.

I will work on it.

Cheers
Truman