Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Dec 2000
    Location
    North Epping, New South Wales, Australia
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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?

    Thanks in advance.
    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20> <font face="BrushScript BT"> Cees </font face=brush>
    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18> <img src=/S/flags/Netherlands.gif border=0 alt=Netherlands width=30 height=18>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    Lounger
    Join Date
    Dec 2000
    Location
    North Epping, New South Wales, Australia
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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?
    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20> <font face="BrushScript BT"> Cees </font face=brush>
    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18> <img src=/S/flags/Netherlands.gif border=0 alt=Netherlands width=30 height=18>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #6
    Lounger
    Join Date
    Dec 2000
    Location
    North Epping, New South Wales, Australia
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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".
    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20> <font face="BrushScript BT"> Cees </font face=brush>
    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18> <img src=/S/flags/Netherlands.gif border=0 alt=Netherlands width=30 height=18>

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #8
    Lounger
    Join Date
    Dec 2000
    Location
    North Epping, New South Wales, Australia
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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..................
    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20> <font face="BrushScript BT"> Cees </font face=brush>
    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18> <img src=/S/flags/Netherlands.gif border=0 alt=Netherlands width=30 height=18>

Posting Permissions

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