Broken/offset X-axis on a time scale

Hi,

I am trying draw line charts with a broken/offset x-axis
with the x-axis being on a time-scale.

I am mainly trying to show time kinetics of immune data at
first few time points (2, 5, 9 and 12 weeks) and then
split the graph and show data for same individual at 1, 2,
and 3 years down the line.

One way I am trying to do this is by changing the dates
for the week time points to months so that that portion of
the graph is stretched out and then manually labelling the
time points as weeks and years. But the graph dosent look
too good.

Could you let me know if there is a better way to do this?

Thank you,
Lakshmi

See the responses in a concurrent discussion on the same subject in the
same newsgroup.

--
Regards,

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

In article ,
says...
Hi,

I am trying draw line charts with a broken/offset x-axis
with the x-axis being on a time-scale.

I am mainly trying to show time kinetics of immune data at
first few time points (2, 5, 9 and 12 weeks) and then
split the graph and show data for same individual at 1, 2,
and 3 years down the line.

One way I am trying to do this is by changing the dates
for the week time points to months so that that portion of
the graph is stretched out and then manually labelling the
time points as weeks and years. But the graph dosent look
too good.

Could you let me know if there is a better way to do this?

Thank you,
Lakshmi