Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 wrote in message ... 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
|
|||
|
|||
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 wrote in message ... 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
|
|||
|
|||
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 , 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i change data on the x or y axis... | Charts and Charting in Excel | |||
change axis info on radar charts | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
How can I change typesetting (spacing, etc.) of bar chart axis lab | Charts and Charting in Excel |