Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default how can i make a line chart from matrix(both row and col) of data


  #2   Report Post  
Posted to microsoft.public.excel.charting
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
...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM
Combined bar and line chart (two Y axis) how to make excel know which data goes where Bugjam1999 Charts and Charting in Excel 2 September 22nd 05 11:57 AM
make line in chart start at y axis Tone Charts and Charting in Excel 1 May 5th 05 09:23 AM
How do I make a section of a chart line dotted? odcltd Charts and Charting in Excel 2 January 22nd 05 02:26 AM
How do I make a section of a chart line dotted? odcltd Charts and Charting in Excel 0 January 21st 05 09:39 AM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"