ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how can i make a line chart from matrix(both row and col) of data (https://www.excelbanter.com/charts-charting-excel/162181-how-can-i-make-line-chart-matrix-both-row-col-data.html)

Gourav

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


Jon Peltier

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
...





All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com