Need Help with graph

[sachin30us]

So i am making a graph o fthe following data A1 to A12 have month Jan to Dec
B1 to B6 have 1 2 4 5 6 and C7 to C12 have 7 8 9 10 12 in the respective months . I want to show a continuous line graph on the X axis.. so that when the graph is don i have a line connecting 1 2 4 5 6 and then another line starting from point 7 8 9 10 12.

Everytime i do the graph, the second series starts with 0 and goes to 7 8 9 10 and 12. I also want it to be on one Y axis and i modified that setting but still cant get the graph to start from 7 once 1 to 6 are drawn.

Please help

 

[cyrilbrd]

Hi,
are you trying to do a line chart and would like the chart not to be discontinued?
what version of excel are you using?
given in A1

Excel 2013
	A	B	C
1	dates	data_1	data_2
2	Jan	1
3	Feb	2
4	Mar	3
5	Apr	4
6	May	5
7	Jun	6	6
8	Jul		7
9	Aug		8
10	Sep		9
11	Oct		10
12	Nov		11
13	Dec		12
sachin30us

chart data range is =' sachin30us '!$A$1:$C$13
series name 1 is =' sachin30us '!$B$1
series values 1 is =' sachin30us '!$B$2:$B$13
series name 2 is =' sachin30us '!$C$1
series values 1 is =' sachin30us '!$C$2:$C$13
axis label range is =' sachin30us '!$A$2:$A$13
Is this what you have?
what would you want to see instead?

 

[Jon Peltier]

If C1:C6 are not empty, but contain a formula, those cells are not blank even if the formula returns "". This is text, which the chart thinks has a value of zero.

Those cells have to be truly blank (no formula), or the formula has to return #N/A, for the chart not to draw markers at zero. Use NA() in the formula to return #N/A.