Broken/offset X-axis on a time scale

G

Guest

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
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Broken/Offset X-axis on a time-scale 6
broken scales for X axis 5
x-axis scaling 5
Chart with differing x axis 1
Combining a 2-D column graph and a 2-D line graph on the same char 3
Line Chart - Problems with labeling X-Axis 3
Axis labels offset from grid line 0
Constant % on X axis 2

Top