how can i make a line chart from matrix(both row and col) of data

J

Jon Peltier

Select the data, and create the chart. By default, Excel is likely to use
the first column as X values (or category labels) and the first row as
series names, if the data is plotted by column. If Excel has trouble with
this, clear the top left cell of the range (the intersection of series names
and category labels/X values) and try again.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Adding a big matrix in Word 2013 5
Creating a Chart on form from selected data in query. 0
Adding a line to a population bar chart 0
Pivot Chart - X-axis labels when adding data 0
Creating a Line graph 6
very odd bubble chart problem 3
make column headings automatically appear as axis chart labels 1

Top