Chart showing one line for several rows

=?Utf-8?B?UEVB?=

Guest

Posts: n/a

30th Aug 2005

I have rows with varying number of filled (with figures) cells (from 1 to 100
per row). I want to create a chart showing a line where the first data point
is the first cell in the first row and the last datapoint is the last cell in
the last row.
Ex.
a b c d e f
1 500 450 525
2 495
3 502 465 515 498 507 492
4 465 516

The chart has to show this line:
500 450 525 495 502 465 515 498 507 492 465 516

How can I do it automicaly (macro) because I have to do the operation agian
and again.
Regards

« Auto sorting a table | graph does not show all plotted points »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Showing totals in data table in a line chart	burke8190	Microsoft Excel Charting	3	10th Dec 2008 04:58 PM
Data showing incorrectly on line chart	=?Utf-8?B?Z29ib25uaWVnbw==?=	Microsoft Excel Charting	1	15th Jun 2006 07:56 PM
Data showing incorrectly on line chart	=?Utf-8?B?Z29ib25uaWVnbw==?=	Microsoft Excel Charting	1	7th Jun 2006 09:27 AM
Combination chart - want only ONE series showing as a line, not 2.	=?Utf-8?B?c2luY2Fh?=	Microsoft Excel Charting	1	26th Jan 2006 10:28 AM
30 day Line Chart showing totals of 3 fields per day	=?Utf-8?B?U2hlcnls?=	Microsoft Access Queries	0	14th Dec 2004 05:39 PM