+ Reply to Thread
Results 1 to 4 of 4

Automatic Change of X-axis

  1. #1
    Jan
    Guest

    Automatic Change of X-axis

    Dear all,

    I have a chart with on the X-axes the age of a person until his retirement
    age.

    My problem is now: how can I start my excel chart with a starting age of 25
    till retirement (65) for a certain person, but when I take another person my
    chart have to start with starting age 45, I will get a chart starting from 45
    till 65. So I want to change my starting point depending on the person.

    Best regards,
    Jan



  2. #2
    R.VENKATARAMAN
    Guest

    Re: Automatic Change of X-axis

    if these are different charts for each person create an xy scatter chart.
    with correct x axis. rightlcick x axis and click format axis choose x axis
    and change the minimum and maximum to suit you



    <Jan@discussions.microsoft.com> wrote in message
    news:F482919F-64FC-43ED-972C-30192B77A2AC@microsoft.com...
    > Dear all,
    >
    > I have a chart with on the X-axes the age of a person until his retirement
    > age.
    >
    > My problem is now: how can I start my excel chart with a starting age of

    25
    > till retirement (65) for a certain person, but when I take another person

    my
    > chart have to start with starting age 45, I will get a chart starting from

    45
    > till 65. So I want to change my starting point depending on the person.
    >
    > Best regards,
    > Jan
    >
    >




  3. #3
    Jan
    Guest

    Re: Automatic Change of X-axis

    It is one chart and 200 persons. I just change the data.

    Jan

    "R.VENKATARAMAN" wrote:

    > if these are different charts for each person create an xy scatter chart.
    > with correct x axis. rightlcick x axis and click format axis choose x axis
    > and change the minimum and maximum to suit you
    >
    >
    >
    > <Jan@discussions.microsoft.com> wrote in message
    > news:F482919F-64FC-43ED-972C-30192B77A2AC@microsoft.com...
    > > Dear all,
    > >
    > > I have a chart with on the X-axes the age of a person until his retirement
    > > age.
    > >
    > > My problem is now: how can I start my excel chart with a starting age of

    > 25
    > > till retirement (65) for a certain person, but when I take another person

    > my
    > > chart have to start with starting age 45, I will get a chart starting from

    > 45
    > > till 65. So I want to change my starting point depending on the person.
    > >
    > > Best regards,
    > > Jan
    > >
    > >

    >
    >
    >


  4. #4
    Tushar Mehta
    Guest

    Re: Automatic Change of X-axis

    It would have to be with programmatic support. For a ready-made
    solution see
    AutoChart Manager
    http://www.tushar-mehta.com/excel/so...art/index.html

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <F482919F-64FC-43ED-972C-30192B77A2AC@microsoft.com>,
    Jan@discussions.microsoft.com says...
    > Dear all,
    >
    > I have a chart with on the X-axes the age of a person until his retirement
    > age.
    >
    > My problem is now: how can I start my excel chart with a starting age of 25
    > till retirement (65) for a certain person, but when I take another person my
    > chart have to start with starting age 45, I will get a chart starting from 45
    > till 65. So I want to change my starting point depending on the person.
    >
    > Best regards,
    > Jan
    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1