Graph for a formulated table

[kalyan338]

Hi,


HOW TO DRAW A CHART FOR A TABLE WHICH CONTAINS FORMULAS. I DRAW A CHART BY SELECTING CELLS AND INSERTING A CHART BY INSERT CHART AT TOP LEFT CORNER.BUT IT DOES NOT PLOT A CHART.
CAN ANY ONE PLEASE PROVIDE THE INFORMATION.

		12.10.2016	15.10.2016	18.10.2016	20.10.2016
LSSW	RATING	3	2	2	2
	SIZE	20	20	20	20
GW	RATING	3	2	3	4
	SIZE	40	34	36	28
BW	RATING	3	5	6	4
	SIZE	42	24	23	28

<tbody>
</tbody>

THESE CELLS CONTAINS (=LEFT(xxx,1) AND =RIGHT(xxx,2)) FORMULAS.

 

[thisoldman]

Charts can only plot numeric values; your formulas return text. You have to force the formulas to return numbers.

Try changing the formulas to =1*LEFT(xxx,1) and =1*RIGHT(xxx,2)

 

[kalyan338]

THANK YOU ITS WORKING.BUT HERE ONE MORE QUESTION HOW TO I CHANGE FROM SHEET1 TO SHEET2. I HAVE TO ENTERED THE VALUES IN SHEET1 BUT THE TABLE WITH FORMULAS HAS TO BE REQUIRED FOR SHEET2.WHEN I ENTERED THE FRACTION IN SHEET1 IT HAS TO SEPERATE THE NUMERATOR AND DENOMINATOR IN SHEET2 SHEET WHICH I HAVE TO DRAW A GRAPH.


Ex: 2/24 IN B12 AT SHEET 1 AND I HAVE TO SEPERATE IN SHEET2 TO DRAW A CHART.

 

[thisoldman]

Please, Kalyan338, don't use all capitals—your post is impossible to read. You get faster responses if you use proper capitalization and punctuation.

Try this: http://www.keynotesupport.com/excel-basics/excel-linking-worksheets.shtml