Fixing the X-axis for a line plot
 

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.

Fixing the X-axis for a line plot
 

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.

Fixing the X-axis for a line plot
 

Hide the source data (either rows of columns for days with no data), then
setup yur chart to not showing hidden values - when ur source data contain
dates with no data.
Or, change ur x-axis type to text instead of date, or change x-axis to
categories.

"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.