ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pack data columns into one serie only (https://www.excelbanter.com/excel-discussion-misc-queries/55481-pack-data-columns-into-one-serie-only.html)

N! Xau

Pack data columns into one serie only
 
Hi,
I have data for different years, where each row represents one year, 1
column for each month.
A perfect sample is the archive for this ng:
http://groups.google.com/group/micro...cel.misc/about

I want a graph showing data from the table at the bottom page, since
jan 1997 to nowadays,
with ONE serie only.
I can easily save the data into a text file and then import it into
excel.
But I still have the rows/column problem. I want to avoid copy each
month data into the same column, before design the graph.

How is that possible?
Hope my question is clear.

thanks
N! Xau



All times are GMT +1. The time now is 12:10 AM.

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