The best site for charting question is:
http://peltiertech.com/Excel/Charts/
I recommend you to search for your question in this site.
I haven't worked with charts for a while but if I recall correctly, there is
a missing data option where you can ignore those data, which you get rid of
straight line but I don't remember where is it.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Lady Excel" wrote:

Hello,

I am trying to fix the x-axis to make my line plot more usefull. The problem
is that I have data from Dec 3 to 16 and then Jan 16 to 20. So, the middle of
the chart is just a straight line. Is there any way I can split the axis and
have two differnt start and end dates? Please help me, if possible.