Want to draw a single Line Chart taking data from a 12x20 table
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Line Chart from table Data
0
Answers
1
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:
- go to the Insert tab
- from the Charts section, click on the down arrow of Insert Line or Area Chart
- click on the upper left symbol of the 2-D section and your chart will appear on the same sheet as the table
- (if the chart has the wrong x and y axes, right click on chart then click Switch Row/Column and a different form will be displayed).
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.
Discussion
The figures are date and net worth. Your suggestion works if all the data is in one line. How to jump after 12th figure to the new line?
narnal Dec 2, '20 at 10:29 pm
If the table is 12 rows high, including a header, the chart should show 11 lines of networth v. time.
To graph just a single net worth line, see Revision 1 to my Answer above.
If that is not you meant, please edit your Question to clarify, preferably adding a file including the chart you created. It can be test data if you like.
To graph just a single net worth line, see Revision 1 to my Answer above.
If that is not you meant, please edit your Question to clarify, preferably adding a file including the chart you created. It can be test data if you like.
John_Ru (rep: 6142) Dec 3, '20 at 1:37 am
Hi Narnal. Did my answer work? If so, did you vote up my Answer rather than Select it? I can't tell really.
John_Ru (rep: 6142) Dec 5, '20 at 4:11 am