Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
multiple rows and column, chart into 1 series?
select the first series and chart it, then goto <chart<source 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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Change a Column list into multiple rows & columns | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
create chart from series grouped by value in another column | Charts and Charting in Excel | |||
generate multiple rows based on cell value | Excel Worksheet Functions |