# Thread: xy chart (excel 2003)

1. ## xy chart (excel 2003)

1. In my xy chart I get a lot of spare space around the chart which I like to eliminate and just have the chart area the same size as the chart without resizing. Is that possible?

2. Can I rotate the axis in the xy chart?

2. ## Re: xy chart (excel 2003)

1) Click inside the plot area of the chart. Then use the handles on the corners and the midpoints of the sides of the plot area to resize it.

2) No. The x axis in an xy chart is always horizontal and the y axis is vertical.

3. ## Re: xy chart (excel 2003)

Thanks Hans,

It is so obvious now. First reduce the size of the external perimeter and than resize the chart.

Thanks nad Merry Christmas. Any snow? and skating yet?

4. ## Re: xy chart (excel 2003)

Merry Christmas to you too.

Weather is dull but mild (for winter) at the moment - completely overcast and temperatures around 6 C at night, 9 C during the day. No White Christmas.

Colder weather is forecast for next week, with temperatures below 0 C during the night, but not enough to make the canals freeze over. And if there is snow, it'll probably be only wet snow.

5. ## Re: xy chart (excel 2003)

2. As Hans indicates you can not rotate: X is Hor and Y is vert. You can switch your ranges around which would "flip" your data set...

Be aware of "convention" however. The X-Axis is considered the "independent" variable and the Y-axis is for the "dependent" variables.

Steve

6. ## Re: xy chart (excel 2003)

As a coach, I am using thexy chart as a "polar plot" for the position of lawn bowls.
I can see the distance and angle from the Jack., whether the bowl has crossed the head (y-axis), are too short or too long or in the "key-hole" - within a metre of the Jack
With the use of "xy chart labeller add-in" and making a video of the bowler's delivery this can be of great benefit to the bowler.
Is it correct that the "xy chart" has the +ve x-axis 0 degrees to the right and goes in anti-clockwise direction to 360 degrees

While I would prefer the "polar plot add-in" it does not have a "chart labeller".

7. ## Re: xy chart (excel 2003)

I do not what addin you are using but the <img src=/S/free.gif border=0 alt=free width=30 height=15>FunChrt6 by (Stephen Bullen) just creates a standard XY so data labels can be added manually, with VB, or the <img src=/S/free.gif border=0 alt=free width=30 height=15> Rob Bovey addin XY Chart Labeler

Steve

8. ## Re: xy chart (excel 2003)

I took me a while - happens when you get older - must the Big Cheese's wine cellar <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> , but it appears I have been able to put a graph in to show what I have in mind.

A picture is a thousand words..................

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•