Facing problem with line graph

[ashuztech]

Hi,


I have a quality report, where I want to show the graph of employee's quality & average of others. but the line starts from 1st point of X-Axis, Is it possible to start that line from joint of X-Axis & Y-Axis.


e.g-


100%|

075%|

050%|

025%|____|________|_______|___

00%...........A...............B..............C


The graph lines start from A - B - C, It should be started from 0 and the end point should be their respective %age.


Please help me in this,

Thank you.


Annen

 

[Faseeh]

Hi Annen,


Try to plot that line (that you want to be start from zero) on secondary X-Axis and change its graph type to scatter one and add a trend line. That will start that line from zero (Beyond category A).


Regards,

Faseeh

 

[atulrajratna]

Hi Annen,


I'm agree with Faseeh

Suppose the table is-


_| A | B | C |

1| 0 | 1 |

2| 0 |45%|

3|


So the data source will be like this-

Values in X-Series: =Sheet1!$A$1:$B$1 (i.e- 0,1)

Values in Y-Series: =Sheet1!$A$2:$B$2 (i.e- 0,45%)


so the line will start from 0, you can also add more legends.

Try with this.


Regards,

Atul Rajratna

 

[ashuztech]

Hi,


Sorry for the delay friends.. I was out of office.

I tried with your suggestions.. even I have got some more ideas from that and the sheet is working fine, too good actually.


Thanks Faseeh, Thanks Atul..

And Thanks Chandoo!


Annen