Want to draw a single Line Chart taking data from a 12x20 table
Want to draw a single Line Chart taking data from a 12x20 table
Narnal
Your question is rather vague (you don't say what your rows and columns or data are) but to draw a chart in your sheet...
Select your table then:
For more information, go to the Charts and Graphs in Excel section in the Tutorials section of TeachExcel. If you want to do it in VBA, start with Don's tutorial Guide to Creating Charts with a Macro in Excel
Revision 1: If you want a chart showing only a single line of the table, follow the instructions above but rather than "Select your table", click and drag to select the header row of your table then Ctrl + click/drag to select the row you require (say row 12). Then go to Insert etc.
Hope this solves your problem. If so, please mark it as Selected.