View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default how can i make a line chart from matrix(both row and col) of data

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gourav" wrote in message
...