A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

multiple rows and column, chart into 1 series?



 
 
Thread Tools Display Modes
  #1  
Old March 8th, 2006, 05:42 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default multiple rows and column, chart into 1 series?


Hi,
I have a table of data let say 10 rows and 50 columns, total 500 data
points.
I would like to chart all 500 points into a single continuous series.
But i keep getting 10 series each have 50 data points.

Thanks in advance,
Zawa


--
Zawa
------------------------------------------------------------------------
Zawa's Profile: http://www.excelforum.com/member.php...o&userid=32263
View this thread: http://www.excelforum.com/showthread...hreadid=520172

  #2  
Old March 8th, 2006, 06:21 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default multiple rows and column, chart into 1 series?

select the first series and chart it, then goto chartsource data series
click at the end of the "y" entry and enter a comma and select the second
row data, enter another comma, and contiue for the 10 rows. hit enter and
they should be one series.

"Zawa" wrote:


Hi,
I have a table of data let say 10 rows and 50 columns, total 500 data
points.
I would like to chart all 500 points into a single continuous series.
But i keep getting 10 series each have 50 data points.

Thanks in advance,
Zawa


--
Zawa
------------------------------------------------------------------------
Zawa's Profile: http://www.excelforum.com/member.php...o&userid=32263
View this thread: http://www.excelforum.com/showthread...hreadid=520172


  #3  
Old March 8th, 2006, 06:33 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default multiple rows and column, chart into 1 series?

The obvious answer is to put the numbers into a single column.

Setting up your data properly eliminates 99% of the difficulties people have
with Excel charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Zawa" wrote in message
...

Hi,
I have a table of data let say 10 rows and 50 columns, total 500 data
points.
I would like to chart all 500 points into a single continuous series.
But i keep getting 10 series each have 50 data points.

Thanks in advance,
Zawa


--
Zawa



  #4  
Old March 8th, 2006, 07:52 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default multiple rows and column, chart into 1 series?


bj,
I try that and I could not get more than 13 rows in there. There is a
character limit for "y"

Jon,
The data is from another department and they want to keep in seperate
row/column for another purpose.

I might have to manually copy and paste into one column. there are a
lot of sheets I have to do it on, cause they have a lot of data
history.

Is there a command or macro where I could run and just copy and past
many columns into one column?


--
Zawa
------------------------------------------------------------------------
Zawa's Profile: http://www.excelforum.com/member.php...o&userid=32263
View this thread: http://www.excelforum.com/showthread...hreadid=520172

  #5  
Old March 9th, 2006, 01:23 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default multiple rows and column, chart into 1 series?

Are they requiring you to do something with the information? Or are you
requesting the data from them. If it's the former, I'd get them to format it
a little more appropriately. Which might be like pulling teeth... I'm a big
proponent of keeping the main data in a flat database kind of format, and if
you need a special layout for screen display, or printing, or charting, or
whatever, then you link your specially formatted sheet to the main data
table.

Probably you could cobble together a macro to take their ugly format and fix
it up, but it would be different from one that I would need for someone
else's data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Zawa" wrote in message
...

bj,
I try that and I could not get more than 13 rows in there. There is a
character limit for "y"

Jon,
The data is from another department and they want to keep in seperate
row/column for another purpose.

I might have to manually copy and paste into one column. there are a
lot of sheets I have to do it on, cause they have a lot of data
history.

Is there a command or macro where I could run and just copy and past
many columns into one column?


--
Zawa
------------------------------------------------------------------------
Zawa's Profile:
http://www.excelforum.com/member.php...o&userid=32263
View this thread: http://www.excelforum.com/showthread...hreadid=520172



  #6  
Old March 10th, 2006, 01:21 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default multiple rows and column, chart into 1 series?


I found a quick way to get all data into one column, instead of copying
and paste.

Using excel analysis tool (if there is no Data Analysis, go to help and
install this tool set)

Tool - Data Analysis - Sampling

select input range, sampling period 1, output option.


--
Zawa
------------------------------------------------------------------------
Zawa's Profile: http://www.excelforum.com/member.php...o&userid=32263
View this thread: http://www.excelforum.com/showthread...hreadid=520172

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Worksheet Functions 23 January 30th, 2006 07:16 PM
Change a Column list into multiple rows & columns angelface Worksheet Functions 3 January 28th, 2006 02:23 AM
Need to Improve Code Copying/Pasting Between Workbooks David General Discussion 1 January 6th, 2006 04:56 AM
Ineffective change of plot order in series formula Jon Peltier Charts and Charting 3 May 30th, 2004 02:15 AM
add vertical line to floating bar chart, still trying bbxrider Charts and Charting 6 January 28th, 2004 12:42 AM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.